A multiple-table delete cannot apply any join.
(a) True
(b) False
This question was addressed to me during an interview.
This key question is from Enabling or Disabling LOCAL Capability for LOAD DATA in section General MySQL Administration of MySQL
(a) True
(b) False
This question was addressed to me during an interview.
This key question is from Enabling or Disabling LOCAL Capability for LOAD DATA in section General MySQL Administration of MySQL
Right option is (b) False
For explanation: In MySQL, a multiple table ‘DELETE’ operation can be performed on the tables combined using any kind of ‘JOIN’ operation. The syntax also allows for deleting rows from multiple tables at once.