Home » MYSQL » Server SQL Mode » Question
  1. Which of the following commands sets the SQL mode as TRADITIONAL?
    1. –sql_mode=’TRADITIONAL’
    2. –sqlmode=’TRADITIONAL’
    3. –sql.mode=’TRADITIONAL’
    4. –sql-mode=’TRADITIONAL’
    5. None of these
Correct Option: D

When the server starts, the command –sql-mode=’TRADITIONAL’ can be used to set the SQL mode as ‘TRADITIONAL’. This can be stored in an option file or can be directly executed on the command line.

Your comments will be displayed only after manual approval.