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 vote188 views2 answers
Sql split string by space
SQL
6 votes164 views2 answers
Difference between join vs union
SQL
0 vote142 views1 answer
Insert or update cassandra
SQL
4 votes175 views5 answers
Get last query in codeigniter 4
SQL
10 votes154 views4 answers
SELECT FROM WHERE
SQL
5 votes171 views1 answer
Oracle get ddl
SQL
0 vote116 views1 answer
Mysql offset from bottom
SQL
0 vote184 views1 answer
Month mysql
SQL
0 vote164 views1 answer
Get initial in sql
SQL
2 votes149 views2 answers
Set database timezone mysql
SQL