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 vote217 views1 answer
Isnull sql server
SQL
0 vote317 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
4 votes215 views1 answer
Id increment ms sql server
SQL
-1 vote194 views2 answers
Postgresql user permissions to database
SQL
0 vote225 views1 answer
Mysql utc timestamp
SQL
2 votes203 views1 answer
Sql like variable
SQL
0 vote216 views1 answer
Check if has alpha characters sql
SQL
0 vote240 views1 answer
Sql server beginning of month
SQL
1 vote194 views3 answers
How to truncate foreign key constraint table
SQL
3 votes222 views3 answers
Start postgresql ubuntu
SQL