티스토리 뷰

공부

[MySQL] default value

seunggabi 승가비 2020. 6. 13. 21:02
ALTER TABLE table1 ADD COLUMN foo INT DEFAULT 0;

https://stackoverflow.com/questions/3569347/adding-a-new-sql-column-with-a-default-value

 

Adding a new SQL column with a default value

I am looking for the syntax to add a column to a MySQL database with a default value of 0 Reference

stackoverflow.com

 

댓글
댓글쓰기 폼