Home » MYSQL » Mysql miscellaneous » Question
  1. The synonym for last_insert_id session variable is _____________.
    1. sql_big_selects
    2. sql_auto_is_null
    3. insert_id
    4. identity
    5. None of these
Correct Option: D

The session only system variable ‘identity’ is a synonym for the ‘last_insert_id’ session variable. Setting ‘last_insert_id’ specifies the value to be returned by the function ‘LAST_INSERT_ID()’.



Your comments will be displayed only after manual approval.