scott.marlowe wrote:
On Fri, 11 Oct 2002, Jeff Davis wrote:

I agree with your message except for that statement. MySQL alter table provides the ability to change column types and cast the records automatically. I remember that feature as really the only thing from MySQL that I've ever missed.
Of course, it's not that wonderful in theory. During development you can easily drop/recreate the tables and reload the test data; during production you don't change the data types of your attributes.

But in practice, during development it's handy sometimes.

I still remember a post from somebody on the phpbuilder site that had changed a field from varchar to date and all the dates he had got changed to 0000-00-00.

He most unimpressed, especially since he (being typical of a lot of MySQL users) didn't have a backup.
Couldn't he just do ROLLBACK? ;-)

(for the humor impaired, that's a joke...)

Mike Mascari

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to