mysql数据库问题：如下

Question

是面试题来的：
有两张表book_a和book_b，有字段book_id,book_name,book_code（书的编号）等，删除book_a表中和book_b表中book_id表字段相同的记录?
下面为什么不对？该怎么写？
delete from book_a , book_b where book_a.bookid=book_b.book_id
我没分了，不知谁能帮我写出正确的来?

Answer 1

delete book_a, book_b from book_a , book_b where book_a.bookid=book_b.book_id;
指定从book_a和book_b删除重复记录。
delete book_a, book_b from book_a , book_b where book_a.bookid=book_b.book_id and book_id = 1; 指定删除特定记录。