http://cgd.idea-sketch.com/index.php?action=history&feed=atom&title=SQL_-_Datens%C3%A4tze_l%C3%B6schen
SQL - Datensätze löschen - Versionsgeschichte
2026-08-14T22:21:40Z
Versionsgeschichte dieser Seite in ComeniusWiki
MediaWiki 1.43.9
http://cgd.idea-sketch.com/index.php?title=SQL_-_Datens%C3%A4tze_l%C3%B6schen&diff=2767&oldid=prev
F59Fuchs am 1. Mai 2014 um 12:41 Uhr
2014-05-01T12:41:49Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="de">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version vom 1. Mai 2014, 12:41 Uhr</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l12">Zeile 12:</td>
<td colspan="2" class="diff-lineno">Zeile 12:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><syntaxhighlight lang="sql"></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><syntaxhighlight lang="sql"></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>DELETE FROM LEHRER</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>DELETE FROM LEHRER</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>WHERE LehrerNr = 1</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>WHERE LehrerNr = 1<ins style="font-weight: bold; text-decoration: none;">;</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></syntaxhighlight></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></syntaxhighlight></div></td></tr>
</table>
F59Fuchs
http://cgd.idea-sketch.com/index.php?title=SQL_-_Datens%C3%A4tze_l%C3%B6schen&diff=2765&oldid=prev
F59Fuchs: Die Seite wurde neu angelegt: „Der DELETE - Befehl ermöglicht es, einen Datensätz innerhalb einer Tabelle zu löschen. <u>Allgemein:</u><br> <syntaxhighlight lang="sql"> DELETE FROM <Tab…“
2014-05-01T12:37:56Z
<p>Die Seite wurde neu angelegt: „Der DELETE - Befehl ermöglicht es, einen Datensätz innerhalb einer Tabelle zu löschen. <u>Allgemein:</u><br> <syntaxhighlight lang="sql"> DELETE FROM <Tab…“</p>
<p><b>Neue Seite</b></p><div>Der DELETE - Befehl ermöglicht es, einen Datensätz innerhalb einer Tabelle zu löschen.<br />
<br />
<u>Allgemein:</u><br><br />
<br />
<syntaxhighlight lang="sql"><br />
DELETE FROM <Tabellenname><br />
WHERE <Bedingung>;<br />
</syntaxhighlight><br />
<br />
<u>Beispiel:</u><br><br />
<br />
<syntaxhighlight lang="sql"><br />
DELETE FROM LEHRER<br />
WHERE LehrerNr = 1<br />
</syntaxhighlight></div>
F59Fuchs