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

1 vote148 views2 answers
Begin transaction sql
SQL
0 vote134 views1 answer
How to export table data from mysql table in sql format
SQL
3 votes165 views3 answers
Sql current year
SQL
9 votes152 views1 answer
Identity insert on sql server
SQL
5 votes148 views2 answers
Create function postgresql
SQL
1 vote126 views2 answers
T sql get foreign key
SQL
0 vote137 views1 answer
Codeigniter 3 get best-selling products
SQL
10 votes182 views1 answer
Oracle all_dependencies
SQL
3 votes171 views2 answers
Find string in stored procedure sql server
SQL
-1 vote131 views1 answer
Mysql case when multiple conditions
SQL