Doesn't have default value mysql

# Option 1: Change table schema and add a DEFAULT to the column
ALTER TABLE 'Foo' 
CHANGE COLUMN 'bar' 'bar' INT(11) NOT NULL DEFAULT 0 ;

# Option 2: Turn off strict trans tables
SELECT @sql_mode:=@@GLOBAL.sql_mode;
SET @new_sql_mode:= REPLACE(@sql_mode,',STRICT_TRANS_TABLES','');
SET GLOBAL sql_mode=@new_sql_mode;
# May need to restart service if changes don't immediately take affect

Similar codes

0 vote158 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
7 votes153 views3 answers
Convert ansi sql
SQL
0 vote139 views1 answer
Mysql where don't have string
SQL
24 votes154 views5 answers
List mysql users
SQL
0 vote151 views1 answer
Check if database exists sql
SQL
0 vote167 views1 answer
Oracle step procedure
SQL
3 votes144 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
5 votes166 views2 answers
Get columns number sql
SQL
0 vote145 views1 answer
How to find all children of a record with only parent ID in sql
SQL
8 votes165 views1 answer
Oracle tablespace datafile max size
SQL