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 vote183 views1 answer
Mysql search multiple tables
SQL
22 votes205 views3 answers
Remove all records from table mysql
SQL
1 vote189 views3 answers
Execute sp in sql server
SQL
2 votes191 views4 answers
Check timezone of mysql database
SQL
5 votes198 views3 answers
Mysql check if null or empty string
SQL
0 vote203 views1 answer
Sqlserver now
SQL
4 votes196 views2 answers
Oracle unlock user
SQL
1 vote189 views1 answer
Mamp mysql path mac
SQL
0 vote181 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote190 views1 answer
Bigquery declare
SQL