> > >

MySQL MCQs

What does this statement: DELETE FROM xpto WHERE 1;

Delete all records in table 'xpto' but does not reset the AUTO_INCREMENT sequence

Delete all records in table 'xpto' and reset the AUTO_INCREMENT value to 0;

Throw an error depending on sql mode

Delete all records in table 'xpto' and resets the AUTO_INCREMENT sequence

Answer

Correct Answer: Delete all records in table 'xpto' but does not reset the AUTO_INCREMENT sequence

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it