Examine the statement which executes successfully:
SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ;
You try to create a table with a storage engine that is not available. What will happen?
An error occurs and the create table statement fails.
The server will create the table but it will be unusable until the specified storage engine is available.
The server will create the table but report an error when the first attempt to insert a row is performed.
The server will create the table using the default storage engine.
Submit