Question

Which of the following commands sets the SQL mode as TRADITIONAL?

(a) –sqlmode=’TRADITIONAL’

(b) –sql_mode=’TRADITIONAL’

(c) –sql-mode=’TRADITIONAL’

(d) –sql.mode=’TRADITIONAL’

I got this question by my college professor while I was bunking the class.

This intriguing question originated from Server SQL Mode in division Using SQL to Manage Data of MySQL

Answer 1

The correct choice is (c) –sql-mode=’TRADITIONAL’

The explanation is: 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.