Home » MYSQL » Server SQL Mode » Question
  1. Which statement can be used to specify the sql_mode system variable at runtime?
    1. ASSIGN
    2. CHANGE
    3. SET
    4. SPECIFY
    5. None of these
Correct Option: C

The ‘SET’ statement can change the SQL mode at runtime. For example, the statement SET sql_mode = ‘ANSI_QUOTES’ can be used by a client in its own session specific SQL mode.

Your comments will be displayed only after manual approval.