http://www.griton.net/wiki/index.php?action=history&feed=atom&title=SQL
SQL - Versionsgeschichte
2026-04-20T16:59:30Z
Versionsgeschichte dieser Seite in GRITON
MediaWiki 1.32.0
http://www.griton.net/wiki/index.php?title=SQL&diff=53&oldid=prev
Marko: Created page with "=SQL Scripts= 1. Kundennummer ändern <pre> start transaction; SET FOREIGN_KEY_CHECKS=0; update ofAdressen set idnr = 295489 where idnr = 499017; update `ofadre..."
2015-12-20T21:46:54Z
<p>Created page with "=SQL Scripts= 1. Kundennummer ändern <pre> start transaction; SET FOREIGN_KEY_CHECKS=0; update ofAdressen set idnr = 295489 where idnr = 499017; update `ofadre..."</p>
<p><b>Neue Seite</b></p><div>=SQL Scripts=<br />
<br />
1. Kundennummer ändern <br />
<pre><br />
start transaction;<br />
SET FOREIGN_KEY_CHECKS=0;<br />
update ofAdressen set idnr = 295489 where idnr = 499017;<br />
update `ofadressen-settings` set idnr = 295489 where idnr = 499017;<br />
update `ofadressen-weitere` set idnr = 295489 where idnr = 499017;<br />
update buchAuftrag set kundnr= 295489 where kundnr = 499017;<br />
update buchRechnung set kundnr= 295489 where kundnr = 499017;<br />
SET FOREIGN_KEY_CHECKS=1;<br />
commit;<br />
</pre></div>
Marko