Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /data/e/7/e76990b9-3372-4d88-8089-fce36e16744a/webperfection.net/sub/rady-nosu/wp-content/plugins/seo-ultimate/modules/class.su-module.php on line 1195
Mysql 2 rows swap switch in single sql

August 2, 2012 | In: Programovanie

mysql switch 2 rows – prehodit 2 riadky

Ako prehodit 2 riadky v mysql pomocou jedneho sql

pekne a jednoduche riesenie:

UPDATE mod_player SET name=@tmp:=name, name=surname, surname=@tmp

ziadne join-ovanie, rychle a elegantne 😉

Comments are closed.