https://kb.son-schiet.de/index.php?action=history&feed=atom&title=Convert_empty_to_null%28%29 Convert empty to null() - Versionsgeschichte 2026-07-03T13:10:10Z Versionsgeschichte dieser Seite in Meine persönliche Wissensdatenbank MediaWiki 1.43.0 https://kb.son-schiet.de/index.php?title=Convert_empty_to_null()&diff=52&oldid=prev Martin: Martin verschob die Seite Convert empty to null( nach Convert empty to null() 2026-01-09T20:29:34Z <p>Martin verschob die Seite <a href="/index.php?title=Convert_empty_to_null(" class="mw-redirect" title="Convert empty to null(">Convert empty to null(</a> nach <a href="/index.php?title=Convert_empty_to_null()" title="Convert empty to null()">Convert empty to null()</a></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="de"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Nächstältere Version</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Version vom 9. Januar 2026, 22:29 Uhr</td> </tr><tr><td colspan="2" class="diff-notice" lang="de"><div class="mw-diff-empty">(kein Unterschied)</div> </td></tr></table> Martin https://kb.son-schiet.de/index.php?title=Convert_empty_to_null()&diff=50&oldid=prev Martin am 9. Januar 2026 um 20:28 Uhr 2026-01-09T20:28:50Z <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 9. Januar 2026, 22:28 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l68">Zeile 68:</td> <td colspan="2" class="diff-lineno">Zeile 68:</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;"><br></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;"><br></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>&lt;/syntaxhighlight&gt;</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>&lt;/syntaxhighlight&gt;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></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><ins style="font-weight: bold; text-decoration: none;">[[Kategorie: SQL]]</ins></div></td></tr> </table> Martin https://kb.son-schiet.de/index.php?title=Convert_empty_to_null()&diff=49&oldid=prev Martin: Die Seite wurde neu angelegt: „* Time: BEFORE * Event: INSERT * Source: <syntaxhighlight lang='SQL' line> BEGIN IF (NEW.qualifier = '') OR (NEW.qualifier = 'NULL') THEN SET NEW.qualifier = NULL; END IF; IF (NEW.coll = '') OR (NEW.coll = 'NULL') THEN SET NEW.coll = NULL; END IF; IF (NEW.metaColl = '') OR (NEW.metaColl = 'NULL') THEN SET NEW.metaColl = NULL; END IF; IF (NEW.vial = '') OR (NEW.vial = 'NULL') THEN SET NEW.vial = NULL; END IF; IF (NEW.datu…“ 2026-01-09T20:28:29Z <p>Die Seite wurde neu angelegt: „* Time: BEFORE * Event: INSERT * Source: &lt;syntaxhighlight lang=&#039;SQL&#039; line&gt; BEGIN IF (NEW.qualifier = &#039;&#039;) OR (NEW.qualifier = &#039;NULL&#039;) THEN SET NEW.qualifier = NULL; END IF; IF (NEW.coll = &#039;&#039;) OR (NEW.coll = &#039;NULL&#039;) THEN SET NEW.coll = NULL; END IF; IF (NEW.metaColl = &#039;&#039;) OR (NEW.metaColl = &#039;NULL&#039;) THEN SET NEW.metaColl = NULL; END IF; IF (NEW.vial = &#039;&#039;) OR (NEW.vial = &#039;NULL&#039;) THEN SET NEW.vial = NULL; END IF; IF (NEW.datu…“</p> <p><b>Neue Seite</b></p><div>* Time: BEFORE<br /> * Event: INSERT<br /> * Source:<br /> <br /> &lt;syntaxhighlight lang=&#039;SQL&#039; line&gt;<br /> BEGIN<br /> IF (NEW.qualifier = &#039;&#039;) OR (NEW.qualifier = &#039;NULL&#039;) THEN<br /> SET NEW.qualifier = NULL;<br /> END IF;<br /> IF (NEW.coll = &#039;&#039;) OR (NEW.coll = &#039;NULL&#039;) THEN<br /> SET NEW.coll = NULL;<br /> END IF;<br /> IF (NEW.metaColl = &#039;&#039;) OR (NEW.metaColl = &#039;NULL&#039;) THEN<br /> SET NEW.metaColl = NULL;<br /> END IF;<br /> IF (NEW.vial = &#039;&#039;) OR (NEW.vial = &#039;NULL&#039;) THEN<br /> SET NEW.vial = NULL;<br /> END IF;<br /> IF (NEW.datum1 = &#039;&#039;) OR (NEW.datum1 = &#039;NULL&#039;) THEN<br /> SET NEW.datum1 = NULL;<br /> END IF;<br /> IF (NEW.utmO = &#039;&#039;) OR (NEW.utmO = &#039;NULL&#039;) THEN<br /> SET NEW.utmO = NULL;<br /> END IF;<br /> IF (NEW.utmN = &#039;&#039;) OR (NEW.utmN = &#039;NULL&#039;) THEN<br /> SET NEW.utmN = NULL;<br /> END IF;<br /> IF (NEW.ffShort = &#039;&#039;) OR (NEW.ffShort = &#039;NULL&#039;) THEN<br /> SET NEW.ffShort = NULL;<br /> END IF;<br /> IF (NEW.btListe = &#039;&#039;) OR (NEW.btListe = &#039;NULL&#039;) THEN<br /> SET NEW.btListe = NULL;<br /> END IF;<br /> IF (NEW.subbiotop = &#039;&#039;) OR (NEW.subbiotop = &#039;NULL&#039;) THEN<br /> SET NEW.subbiotop = NULL;<br /> END IF;<br /> IF (NEW.vid = &#039;&#039;) OR (NEW.vid = &#039;NULL&#039;) THEN<br /> SET NEW.vid = NULL;<br /> END IF;<br /> IF (NEW.Bemerkung = &#039;&#039;) OR (NEW.Bemerkung = &#039;NULL&#039;) THEN<br /> SET NEW.Bemerkung = NULL;<br /> END IF;<br /> IF (NEW.atlas = &#039;&#039;) OR (NEW.atlas = &#039;NULL&#039;) THEN<br /> SET NEW.atlas = NULL;<br /> END IF;<br /> IF (NEW.AKHH = &#039;&#039;) OR (NEW.AKHH = &#039;NULL&#039;) THEN<br /> SET NEW.AKHH = NULL;<br /> END IF;<br /> IF (NEW.ZMH = &#039;&#039;) OR (NEW.qualifier = &#039;ZMH&#039;) THEN<br /> SET NEW.ZMH = NULL;<br /> END IF;<br /> IF (NEW.DBLokal = &#039;&#039;) OR (NEW.DBLokal = &#039;NULL&#039;) THEN<br /> SET NEW.DBLokal = DATE_FORMAT(NOW(), &#039;%d.%m.%Y&#039;);<br /> END IF;<br /> IF (NEW.SHMB = &#039;&#039;) OR (NEW.SHMB = &#039;NULL&#039;) THEN<br /> SET NEW.SHMB = NULL;<br /> END IF;<br /> IF (NEW.methode = &#039;&#039;) OR (NEW.methode = &#039;NULL&#039;) THEN<br /> SET NEW.qualifier = &#039;NN&#039;;<br /> END IF;<br /> IF (NEW.biotoptyp = &#039;&#039;) OR (NEW.biotoptyp = &#039;NULL&#039;) THEN<br /> SET NEW.biotoptyp = &#039;NN&#039;;<br /> END IF;<br /> IF (NEW.biotop = &#039;&#039;) OR (NEW.biotop = &#039;NULL&#039;) THEN<br /> SET NEW.biotop = &#039;NN&#039;;<br /> END IF;<br /> END<br /> <br /> &lt;/syntaxhighlight&gt;</div> Martin