delete from tb_document as doc where doc.doc_id in (SELECT dc.doc_id FROM tb_document as dc inner join tb_data_source as ds
on (dc.data_source_id = ds.data_source_id and ds.data_source_group_id = 416) )
error:
1064-You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version fro the right syntax to use near 'where doc.doc_id in(select dc.doc_id from tb_document as dc inner join tb_data_'at line 1
这是什么原因?
on (dc.data_source_id = ds.data_source_id and ds.data_source_group_id = 416) )
error:
1064-You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version fro the right syntax to use near 'where doc.doc_id in(select dc.doc_id from tb_document as dc inner join tb_data_'at line 1
这是什么原因?
on A.data_source_id=B.data_source_id
where B.data_source_group_id = 416