At 15:19 +0100 7/6/06, Rob Desbois wrote:
With the CHANGE clause of ALTER TABLE statement, you must provide
the column definition, so something like this is what you need:
ALTER TABLE actors CHANGE director_id actor_id MEDIUMINT UNSIGNED NOT NULL;
or whatever your original definition is.
Wow! I was right. I'm learning... :-)
--
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]