SQL联接详解
SELECT * FROM a
LEFT JOIN b
ON a.aID =b.bID
SELECT * FROM a
RIGHT JOING b
ON a.aID = b.bID
inner join(相等联接或内联接)
SELECT *
FROM a,b
WHERE a.aID = b.bID
FROM table1 LEFT JOIN table2 ON table1.field1 compopr table2.field2
delete a,b from a left join b on a.id=b.a_id where a.id=1
不能在一个多表DELETE语句中使用ORDER BY或LIMIT
LEFT JOIN b
ON a.aID =b.bID
SELECT * FROM a
RIGHT JOING b
ON a.aID = b.bID
inner join(相等联接或内联接)
SELECT *
FROM a,b
WHERE a.aID = b.bID
FROM table1 LEFT JOIN table2 ON table1.field1 compopr table2.field2
delete a,b from a left join b on a.id=b.a_id where a.id=1
不能在一个多表DELETE语句中使用ORDER BY或LIMIT
扫一扫
2067
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
