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 votes173 views3 answers
Mysql check if null or empty string
SQL
13 votes175 views2 answers
Sql join
SQL
0 vote177 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
26 votes417 views6 answers
Modify column name in sql
SQL
1 vote184 views1 answer
Mysql select if empty result
SQL
0 vote166 views1 answer
Get duplicate entry sql
SQL
2 votes184 views3 answers
How to get second highest salary in each department in sql
SQL
6 votes202 views2 answers
Mysql check auto increment value
SQL
0 vote169 views2 answers
How to update the multiple rows in sql
SQL
0 vote175 views2 answers
Postgresql variable in query
SQL