Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel and Google site.
Adsense
Popular Posts
- PHPWind-- A PHP forum script applcaition in China
- Free host forum is not reliable
- Formatting my post
- Powerful js library datable to export table in pdf, excel, sorting, freezing column and table header fixed (sticky)
- job interview questions (1)
- Set up a child account and set screen time limit in Windows 8
- PHP: add a download as pdf file button in report page
- phpexcel toggle expand and hide column in EXCEL and summary
- WinMerge - file and folder differencing and merging tool for Windows
- PHP connect IBM db2 database in XAMPP
Friday, January 11, 2013
Delete rows in one table from join two tables in MySQL
In MYSQL, we can only select one table from multi tables:
SELECT tableA.* FROM tableA A, tableB B WHERE A.id=B.id AND R.member_id AND B.id=1;
If we use
DELETE FROM tableA A, tableB B WHERE A.id=B.id AND R.member_id AND B.id=1;
This will delete the rows both in tableA and tableB which satisfy the conditions.
So if we only want to delete the rows in tableA, not in tableB?
We can use the following MySQl query
DELETE FROM tableA USING tableA, tableB WHERE tableA.id=tableB.id AND tableB.id=1;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment