As the column set the default value to 0?

There is a column "aprroved" What you need to do to for each record in that column has been set to 0?
June 14th 19 at 20:59
2 answers
June 14th 19 at 21:01
Solution
Once you use a PMA, then set the column layout: default -> defined as -> 0 and the Null checkbox clear if you don't need to use Null. And then when you add a record to the database if the column value isn't specified, 0 will be substituted.
By default there is 0(zero)! what to put?
59d040d59ed17174035866.png PS And check in "NULL" I got it! You need to remove! It is important to me that each entry in the column was aprroved a value of 0 - pearl_McCullough commented on June 14th 19 at 21:04
The default is> defined as -> 0

From the list item as specified , select and enter 0 - nikolas.Stark55 commented on June 14th 19 at 21:07
Thank you!!! - pearl_McCullough commented on June 14th 19 at 21:10
June 14th 19 at 21:03
aprroved INTEGER NOT NULL DEFAULT 0
Please check, whether all right?
59d034beb0b6b037001195.png - pearl_McCullough commented on June 14th 19 at 21:06

Find more questions by tags MySQL