At 0:09 +1000 8/6/06, Mark Sargent wrote:
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);
for changing the name of a column, right? So, why doesn't the below work?
mysql> ALTER TABLE actors CHANGE director_id actor_id;
I'm no great expert myself, but off the top of my head, maybe you
need to specify the type even if it's unchanged (I assume all you
want to do is rename the column?). So supposing director_id was a
SMALLINT(3) UNSIGNED, try:
ALTER TABLE actors CHANGE director_id actor_id SMALLINT(3) UNSIGNED;
Any good?
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
If at first you don't succeed, try, try again.
Then quit. No use being a damn fool about it.
-- W.C. Fields
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]