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 vote191 views1 answer
Pgadmin check database
SQL
0 vote177 views1 answer
Describe in sqlite3
SQL
5 votes213 views1 answer
How to check port number for postgresql
SQL
7 votes166 views1 answer
Sql management studio display line numbers
SQL
0 vote174 views1 answer
How to generate ids in sql
SQL
1 vote176 views1 answer
Sql order by where condition
SQL
0 vote214 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote180 views1 answer
Get server date mysql
SQL
9 votes177 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote226 views1 answer
Sqlite trim
SQL