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 vote199 views1 answer
Intellij mysql set timezone
SQL
11 votes314 views2 answers
Import mysql dump command line windows
SQL
3 votes195 views2 answers
Truncate table
SQL
2 votes178 views2 answers
Get all tables using like
SQL
19 votes187 views6 answers
Sql drop table if exists
SQL
12 votes178 views4 answers
Import mysql database command line linux
SQL
0 vote235 views1 answer
Isnull in sqlite
SQL
0 vote230 views1 answer
Mysql subtract month from timestamp
SQL
0 vote177 views1 answer
Update and keep original value sql
SQL
8 votes230 views2 answers
Default sql server port
SQL