Tag Archives: MySQL

Today I Learned Altering a SQL Column Removes it’s Default Value

Posted on January 12, 2020 by Chris C

This one I actually already knew but temporarily forgot about it so got to relearn it. In MySQL, and many other databases, updating the column with an ALTER statement will remove any properties not explicitly listed. For example, say you … Continue reading →

Posted in Today I Learned | Tagged , , | Comments Off on Today I Learned Altering a SQL Column Removes it’s Default Value