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

1 vote207 views1 answer
Lpad function in sql oracle
SQL
0 vote227 views1 answer
Move table to a different schema
SQL
-2 votes207 views1 answer
Remove root password mysql
SQL
25 votes216 views5 answers
Date in mysql
SQL
0 vote210 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
6 votes219 views2 answers
What is non relational database
SQL
1 vote187 views1 answer
Reutrn string after character sql
SQL
0 vote221 views1 answer
Postgres grep entire database
SQL
0 vote193 views1 answer
Update sqlite
SQL
0 vote199 views1 answer
Get who is hired in specific month in sql
SQL