)|
as well as renaming it from |b| to |c|:
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 get this,
ERROR 1064 (42000): You have an error in your SQL
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,
__
-- Original Message --
FROM: Mark Sargent [EMAIL PROTECTED]
TO:mysql@lists.mysql.com
DATE: Thu, 08 Jun 2006 00:09:45 +1000
SUBJECT: ERROR 1064 (42000): You have an error in your SQL syntax;
Hi All,
gee I really
: ERROR 1064 (42000): You have an error in your SQL syntax;
Hi All,
gee I really hate bugging you all for this. I looked at this page,
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
which has this,
To change column |a| from |INTEGER| to |TINYINT NOT NULL| (leaving the name
the same
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.