RE: mysql: Alter Column

[indrek siitan]

Hei,

> ALTER TABLE testing ALTER COLUMN itemid SET VARCHAR(32) NOT NULL

that should be:
ALTER TABLE tbl_name CHANGE col_name col_name varchar(32) not null;


Rgds,
  Tfr

  --==< [EMAIL PROTECTED] >==< http://www.cafe.ee/~tfr/ >==< +372-50-17621 >==-- 

-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.