已采納回答 / sophia_yu
單表刪除的語法是DELETE ?FROM tbl_name ?[WHERE where_definition]?[ORDER BY ...]??[LIMIT row_count]多表的語法是DELETE??tbl_name[.*] [, tbl_name[.*] ...]?FROM table_references?[WHERE where_definition]在你的代碼快照里面,delete t1 from tdb_goods as t1 left join ( select ...)...這個是多表...
2014-10-20