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 vote207 views1 answer
Show indices in mysql table
SQL
0 vote197 views1 answer
How to declare variable date in mysql
SQL
4 votes215 views2 answers
Mysql delete user if exists
SQL
0 vote188 views1 answer
Oracle for loop on list
SQL
5 votes189 views1 answer
Ora-00054 find lock
SQL
0 vote216 views1 answer
Sql delete dastabase
SQL
1 vote221 views1 answer
Convert to hexadecimal sql
SQL
5 votes295 views1 answer
Oracle source query
SQL
0 vote230 views1 answer
Mysql backup query
SQL
2 votes194 views1 answer
How to find constraints on a table in oracle
SQL