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 vote354 views1 answer
Php select data from mysql database without column name
SQL
12 votes352 views1 answer
Psql drop column
SQL
0 vote350 views1 answer
Create query in where clasue
SQL
1 vote354 views1 answer
Where to locate set password for mysql
SQL
0 vote425 views1 answer
Mariadb change column type
SQL
0 vote307 views1 answer
Now() -1 mysql
SQL
13 votes369 views2 answers
Sql join 3 tables
SQL
6 votes364 views2 answers
Non relational database
SQL
0 vote399 views1 answer
Error code 1451 sql
SQL
0 vote347 views1 answer
Hive batch drop table
SQL