> > >

MySQL MCQs

You have just inserted a new row into a table whose Primary Key has the AUTO_INCREMENT property, without specifying the Primary Key. How would you retrieve the new row's Primary Key from the database?

SELECT LAST_INSERT_ID();

You can't; the row creation would have failed with a Key Constraint error.

GET_AUTO_ID();

SELECT LAST_KEY_INC();

Answer

Correct Answer: SELECT LAST_INSERT_ID();

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