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 vote274 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote254 views1 answer
Mysql delete from where like
SQL
0 vote262 views1 answer
Pgadmin see indexes
SQL
0 vote283 views1 answer
Sql max of two values
SQL
10 votes280 views2 answers
Sql pagination offset
SQL
0 vote255 views1 answer
Hive batch drop table
SQL
0 vote245 views1 answer
Sql right characters
SQL
1 vote264 views1 answer
Mysql view current queries
SQL
0 vote288 views1 answer
Mysql command line top 10
SQL
0 vote273 views1 answer
Select lowest values sql
SQL