4.0版本以上可以用以下方法试试:
DELETE FROM table4 USING table4,temptable4 WHERE table4.param3||table4.param10=temptable4.param3||temptable4.param10
DELETE FROM table4 USING table4,temptable4 WHERE table4.param3||table4.param10=temptable4.param3||temptable4.param10
我在sql_server中可以使用下面的语句实现。
delete table4
from table4 inner join temptable4
on table4.parm1=temptable4.parm1 and table4.parm10=temptable4.parm10但是在mysql下面就没有成功
FROM table-references
[WHERE where_definition]orDELETE [LOW_PRIORITY] [QUICK]
FROM table_name[.*] [, table_name[.*] ...]
USING table-references
[WHERE where_definition]