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 vote366 views1 answer
Bigrock database connection string
SQL
0 vote326 views1 answer
SQL loop with cursor
SQL
2 votes325 views1 answer
Oracle sql day of month from date
SQL
0 vote336 views2 answers
How to install mssql on mac
SQL
0 vote316 views1 answer
Oracle synonym procedure dblink
SQL
0 vote311 views1 answer
Sql get table last modified time
SQL
0 vote386 views1 answer
Generate sql from specific migration ef core
SQL
6 votes334 views2 answers
Non relational database
SQL
0 vote318 views1 answer
Get last updated row sql server
SQL
0 vote330 views3 answers
Postgresql grant alter table to user
SQL