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 vote100 views1 answer
Ms sql database data size
SQL
0 vote102 views1 answer
Python sql last insertend
SQL
2 votes116 views1 answer
Postgresql create schema in specific database
SQL
0 vote128 views1 answer
Sql server is not
SQL
0 vote109 views1 answer
Rails sql query converstion
SQL
3 votes138 views6 answers
Jwt laravel
SQL
0 vote106 views1 answer
How to to get current date in sql
SQL
5 votes109 views1 answer
Sort order on two columns sql
SQL
0 vote103 views1 answer
Mysql wait_timeout
SQL
0 vote104 views1 answer
Mysql command prompt date insert format
SQL