1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
-----------------
select * from t1 t1_alias, t2 t2_alias, t3 t where a=10
-----------------
-----------------
-----------------
SELECT * FROM t1 t, t3 t3 where a=10
-----------------
-----------------
-----------------
UPDATE t1 t, t3 t3 SET a=10
-----------------
-----------------
-----------------
DELETE FROM t1 t, t3 t3
-----------------
-----------------
-----------------
DELETE FROM t1 t, t3 t3 WHERE t.a=1
-----------------
-----------------
-----------------
SELECT * FROM mysql.help_category h, mysql.help_category he
-----------------
-----------------
|