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 vote289 views3 answers
My sql alter table
SQL
0 vote258 views1 answer
Mysql update sequence with order by
SQL
0 vote286 views1 answer
Drop database using terminal postgres
SQL
0 vote285 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote279 views1 answer
Sql tablo hangi sp de
SQL
3 votes294 views3 answers
1396(hy00) mysql error
SQL
3 votes289 views2 answers
Search text in all sql server stored procedure
SQL
0 vote276 views1 answer
Mysql show category once count how many products
SQL
3 votes264 views5 answers
Mysql get last inserted id
SQL
0 vote246 views1 answer
Suse start MySQL
SQL