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

2 votes119 views1 answer
How to get non distinct values in sql
SQL
0 vote110 views1 answer
Sql drop default
SQL
1 vote75 views1 answer
Mysql show attributes of a table
SQL
0 vote113 views1 answer
How to install mysql without admin rights
SQL
0 vote117 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote126 views1 answer
Mysqli last row
SQL
0 vote117 views1 answer
Mysql add text to existing field
SQL
0 vote123 views1 answer
Find and replace database table phpmyadmin
SQL
2 votes117 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote126 views2 answers
Truncate table sqlite
SQL