Changing column types
Posted: Thu Jun 13, 2002 10:49 am
Hi folks,
I have a MySQL database which I have created from exporting a (very large) MS Access db using MyODBC. Some of the column types are not what I would like.
For example, a column type in Access is date/time but the format is just a date (d mmm yyyy). When I print out the contents of the MySQL column, it has extended the format to 2002-06-13 00:00:00 (DATETIME).
How do I change the column type (with data in it) into another type, in this case DATE?
It is not as easy as starting again with the right type, as the last 5 years work will be wasted!
Thanks.
I have a MySQL database which I have created from exporting a (very large) MS Access db using MyODBC. Some of the column types are not what I would like.
For example, a column type in Access is date/time but the format is just a date (d mmm yyyy). When I print out the contents of the MySQL column, it has extended the format to 2002-06-13 00:00:00 (DATETIME).
How do I change the column type (with data in it) into another type, in this case DATE?
It is not as easy as starting again with the right type, as the last 5 years work will be wasted!
Thanks.