Altering a column in a mysql database schema

Sometimes in a web project the initial requirements/blueprint will need adjustment. When you already have a working database table with lots of data in it, you can just blow the table away to change the schema. In this scenario, you have a database of contacts and you were storing the date that the contact was entered in the database in a column named "created_at". Further along the road you discover that you need the time the record was created in addition to the date, but you do not want to lo... read more!

Feb 12, 2009 10:26am by Mike Vandenberghe

Posted in technology | Post Comment