Hi
I am trying to alter a column within a table but am struggling ..
The manual tells me to:
ALTER TABLE tbl_name ALTER COLUMN col_name SET DEFAULT NULL
which I replace with:
ALTER TABLE testing ALTER COLUMN itemid SET VARCHAR(32) NOT NULL
and I get the following:
mysql> ALTER TABLE testing ALTER COLUMN itemid SET VARCHAR(32) NOT NULL;
ERROR 1064: parse error near 'VARCHAR(32) NOT NULL' at line 1
Anybody help please ... ??
Thanks
Darren
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
