Geoffrey-T/tips-mysql.md

Forked from nicolasramy/mysql-cs-01-introduction.md

Created March 4, 2013 16:10

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Geoffrey-T/5083337.js"></script>
Save Geoffrey-T/5083337 to your computer and use it in GitHub Desktop.

Raw

MySQL

CREATE TABLE tableName SELECT ...

DELETE FROM tableName WHERE tableName.fieldName1 = condition1 AND tableName.fieldName2 = condition2

DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id

DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id

DELETE tab1, tab2 FROM tab1 INNER JOIN tab2 WHERE tab1.id = tab2.parent_id AND tab2.value > 3;