[SOLVED] SQL_MODE and TIME_ZONE when creating DATABASE

SQL_MODE and TIME_ZONE when creating DATABASE

What do these options mean, and what are the possible choices when creating the database?

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

#------------------------------------------------------------
#        Script MySQL.
#------------------------------------------------------------

DROP DATABASE if exists BASETEST;
CREATE DATABASE IF NOT EXISTS BASETEST DEFAULT CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;
USE BASETEST;

Solution

SET set's one of MySQL variables. Some of them are system variables some of them are user variables ...

SET SQL_MODE:

SQL_MODE is a system variables and you can see all possible modes in the documentation.

NO_AUTO_VALUE_ON_ZERO :

NO_AUTO_VALUE_ON_ZERO affects handling of AUTO_INCREMENT columns. Normally, you generate the next sequence number for the column by inserting either NULL or 0 into it. NO_AUTO_VALUE_ON_ZERO suppresses this behavior for 0 so that only NULL generates the next sequence number.

SET time_zone :

SET time_zone = "+00:00" Sets the session timezone on UTC.