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

5 votes172 views2 answers
Mysql where in array
SQL
0 vote163 views1 answer
Get id if is not equal in certain table
SQL
3 votes142 views1 answer
Uppercase and lowercase in sql
SQL
4 votes147 views2 answers
Sql vs mysql
SQL
0 vote150 views1 answer
Mysql select where field like in list
SQL
1 vote183 views1 answer
Increase date by one day in sql oracle
SQL
0 vote142 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote152 views1 answer
Postgres where
SQL
-1 vote160 views1 answer
Sql set max value in column
SQL
0 vote150 views1 answer
Longtext sql
SQL