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 vote190 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote184 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote187 views1 answer
Sql server count all tables rows
SQL
1 vote180 views3 answers
Union in sql
SQL
0 vote182 views1 answer
Insert set mysql
SQL
1 vote233 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote191 views1 answer
Mysql root permission denied lost
SQL
0 vote194 views1 answer
Mysql workbench primary key
SQL
0 vote194 views1 answer
Proc sql not in working
SQL
1 vote242 views1 answer
Mysql stop password policy
SQL