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 vote290 views1 answer
How to show index type in postgresql
SQL
6 votes301 views2 answers
Mysql 1 day ago
SQL
0 vote283 views1 answer
Mysql page segment
SQL
0 vote232 views1 answer
Java spring boot connect to sql server
SQL
5 votes277 views1 answer
Oracle get foreign keys on table
SQL
1 vote286 views3 answers
Update from select sqlite
SQL
0 vote292 views1 answer
Login failed for user sql server
SQL
2 votes267 views1 answer
Alter table add multiple columns postgresql
SQL
1 vote255 views1 answer
MySQL AND Operator
SQL
2 votes290 views1 answer
Sql server current date minus 5 years
SQL