Which two keywords cannot be used in multi-table deletes?
A.
USING
B.
ORDER BY
C.
LIMIT
D.
IGNORE
E.
JOIN
Explanation:
Reference:
http://dev.mysql.com/doc/refman/5.0/en/delete.htmlYou can specify multiple tables in a DELETE statement to delete rows from one or more
tables depending on the particular condition in the WHERE clause. However, you cannot
use ORDER BY or LIMIT in a multiple-table DELETE.
BC
BC
From MySQL 5.0 Certification Study Guide by Dubois, Hinz, and Pedersen:
“The ORDER BY and LIMIT clauses normally supported by UPDATE and DELETE aren’t allowed when these statements are usded for multiple-table operations.”
B and C
http://dev.mysql.com/doc/refman/5.7/en/delete.html
If the ORDER BY clause is specified, the rows are deleted in the order that is specified. The LIMIT clause places a limit on the number of rows that can be deleted. These clauses apply to single-table deletes, but not multi-table deletes.
B C