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 vote275 views1 answer
Update set with inner join oracle
SQL
4 votes292 views4 answers
Print pl sql
SQL
0 vote298 views1 answer
How to list function in psql
SQL
0 vote328 views1 answer
Oracle chain step succeeded
SQL
0 vote297 views2 answers
Sql server Insert Into table
SQL
21 votes296 views6 answers
Change column in mysql
SQL
1 vote289 views1 answer
Mysql view current queries
SQL
0 vote283 views1 answer
Mod in sql
SQL
0 vote281 views1 answer
Inser into example
SQL
0 vote230 views1 answer
Denied
SQL