At 18:02 -0400 9/8/04, Rhino wrote:
----- Original Message -----
From: "leegold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 2004 5:31 PM
Subject: Rename a columkn
I sent a previous email w/the wrong subj. - sorry.
The example below renames a col. But can I rename a col. w/out giving
all that type spec. at the end of the statement below. I just want to
rename, everything else stays the same. Thanks.
mysql> ALTER TABLE search CHANGE Description PageDescription
VARCHAR(255) NOT NULL;
Have you tried looking in the manual?
According to http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html, you can
rename a column by including the old name, the new name AND the datatype.
The example they give is:
mysql> ALTER TABLE t1 CHANGE a b INTEGER;
So, you have to supply the datatype but you can apparently omit the null
specification. In your case, I assume you would have to include
'VARCHAR(255)', not just 'VARCHAR', but I could be wrong; the manual doesn't
say explicitly.
The syntax is:
CHANGE [COLUMN] old_col_name column_definition [FIRST|AFTER col_name]
column_definition includes the column attributes (NULL, NOT NULL, DEFAULT,
etc.)
In any case, it is very easy to try the command on a test table just to see
what MySQL allows or prohibits.
Rhino
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]