Based on the code shown, which query deletes any row in the OrderLine table in which the item number is MT03???OrderLine (OrderNum, ItemNum, NumOrdered, QuotedPrice)?Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
A) DELETE FROM OrderLine WHERE ItemNum='MT03' ;
B) DELETE FROM OrderLine WHERE ItemNum=MT03 ;
C) REMOVE FROM OrderLine WHERE ItemNum='MT03' ;
D) REMOVE FROM OrderLine WHERE ItemNum=MT03 ;

Question

Quizplus · Accepted Answer

The correct syntax to delete a row from a table in MySQL is to use the DELETE statement, followed by the table name and the WHERE clause to specify the condition for deleting. In this case, the condition is that the ItemNum column should have the value 'MT03'. Since ItemNum is a string column, it should be enclosed in single quotes. Therefore, only option A satisfies this requirement and is the correct choice. Options B, C, and D either have syntax errors or use incorrect keywords and are not valid MySQL statements.

Based on the Code Shown, Which Query Deletes Any Row