[SOLVED] change table name.

[daveoffy]

I have a table named members, using SQL how can I change the name to profiles?

[corbin]

RENAME TABLE name1 TO name2;

[daveoffy]

for a column will i do RENAME COLUMN c1 To c2?

[Daniel0]

for a column will i do RENAME COLUMN c1 To c2?

 

No, take a look at ALTER TABLE.

[daveoffy]

So I would use...

 

ALTER COLUMN c1 TO c2

[fenway]

There are some ways to rename without using alter, but don't use them... bad form.

[daveoffy]

So am I right?

[fenway]

No, you need to do:

 

ALTER TABLE yourTable CHANGE oldColName newColName <column def>

 

But you NEED to make sure you use the exact same column defn as current exists.

[daveoffy]

what is column def?

[Daniel0]

Stuff like its type, default value, etc.

[daveoffy]

why do I need to put column def? Is there a way to do it without that? Or can you give me an example on how column def looks like?

[Daniel0]

Yes, you do need to do that (hence the capitalized "NEED" in fenway's post).

 

You are telling MySQL this: "In the table something, change the column x to be this: ...". The last part of it is the same syntax as when you are creating a table.

[fenway]

"Show create table" will tell you what it is.