|
Home > Archive > MySQL Server Forum > June 2005 > Alter DATABASE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Angelos 2005-06-03, 7:23 am |
| Hello jsut a quick question...
Is it possible to alter the DATABASE structure after it is CREATED AND
POPULATED WITH RECORDS.
For example RENAME fields, Change datatypes etc...
If not what is the best way of doing it and then restore my data?
I use MySQL - MyISAM tables
Thanks!!!
| |
| Felix Geerinckx 2005-06-03, 7:23 am |
| On 03/06/2005, Angelos wrote:
> Hello jsut a quick question...
> Is it possible to alter the DATABASE structure after it is CREATED
> AND POPULATED WITH RECORDS.
> For example RENAME fields, Change datatypes etc...
http://dev.mysql.com/doc/mysql/en/data-definition.html
--
felix
| |
| Bill Karwin 2005-06-03, 1:23 pm |
| Angelos wrote:
> Hello jsut a quick question...
> Is it possible to alter the DATABASE structure after it is CREATED AND
> POPULATED WITH RECORDS.
> For example RENAME fields, Change datatypes etc...
Yes, ALTER TABLE can do a lot of changes like this. Subject to
limitations that you might expect, for example what should it do with
data if you change a VARCHAR(100) to a VARCHAR(6), or for that matter to
an INTEGER?
http://dev.mysql.com/doc/mysql/en/alter-table.html
Regards,
Bill K.
|
|
|
|
|