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

7 votes178 views1 answer
Alter sequence set current value oracle
SQL
1 vote190 views1 answer
Where date = max(date) in sql
SQL
0 vote182 views1 answer
Mysql count unique in group statement
SQL
2 votes183 views1 answer
Sql update alias
SQL
1 vote188 views1 answer
Load mysql dumb
SQL
0 vote186 views1 answer
Create database like
SQL
1 vote232 views1 answer
Best configuration for display table in sqlplus
SQL
12 votes188 views6 answers
How to install sqlite3 in python
SQL
15 votes195 views6 answers
Drop foreign key mysql
SQL
0 vote199 views1 answer
Default order by in mysql
SQL