FsseInfo: MySQL Alter Table

Revision [835]

Last edited on 2009-06-15 09:44:58 by FsseInfo

Additions:

MySqlAlterEngine
MySqlAlterCharSet

Revision [191]

Edited on 2006-10-04 03:51:36 by FsseInfo

Additions:

MySqlAlterTableIndexs

Revision [189]

Edited on 2006-10-04 03:50:29 by FsseInfo

Additions:

MySqlAlterTableColumns

Deletions:

To resize a column
%%
> alter table mytable change colname colname varchar(newsize)
%%
To rename a column
%%
> alter table mytable change oldcolname newcolname(samesize)
%%
To drop a column
%%
> alter table mytable drop colname
%%

Revision [181]

Edited on 2006-10-02 10:41:02 by FsseInfo

Additions:

To drop a column
> alter table mytable drop colname
----
REFERRERS
{{backlinks}}

Revision [176]

Edited on 2006-10-02 09:03:54 by FsseInfo

Additions:

To resize a column
> alter table mytable change colname colname varchar(newsize)
> alter table mytable change oldcolname newcolname(samesize)

Deletions:

To add remove or resize columns
> alter table mytable change oldcol oldcol varchar(newsize)
> alter table mytable change oldcol oldcolnewcol(samesize)

Revision [175]

Edited on 2006-10-02 09:03:12 by FsseInfo

Additions:

You can use MySQL Alter Table to alter tables
To add remove or resize columns
> alter table mytable change oldcol oldcol varchar(newsize)
To rename a column
> alter table mytable change oldcol oldcolnewcol(samesize)

Deletions:

You can use MySQL Alter Table to add remove or resize columns
alter
table mytable
change oldcol oldcol varchar(newsize)

Revision [143]

The oldest known version of this page was created on 2006-09-20 12:54:15 by FsseInfo