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

4 votes131 views1 answer
Postgres delete last row
SQL
8 votes86 views2 answers
Alter column name in mssql
SQL
9 votes121 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote88 views2 answers
Sql query unique
SQL
0 vote158 views1 answer
Sql to excel pgadmin
SQL
0 vote128 views1 answer
Mysql query to check record exists in database table or not
SQL
1 vote156 views1 answer
How not to sort by average rating
SQL
0 vote137 views1 answer
Unique index in mysql
SQL
-1 vote134 views2 answers
Postgresql get last 10 records
SQL
1 vote122 views1 answer
Local sql server
SQL