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 vote298 views1 answer
Tsql pad left
SQL
1 vote286 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote278 views1 answer
Concatenate columns in table
SQL
0 vote309 views1 answer
Psotgres multiple values
SQL
0 vote307 views1 answer
Sql last 3 rows
SQL
0 vote297 views1 answer
How to move a column to different spot mysql
SQL
4 votes292 views2 answers
Postgresql reset sequence
SQL
17 votes353 views1 answer
Selecting name that contain certain word in sql
SQL
10 votes293 views1 answer
Oracle object dependencies
SQL
1 vote299 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL