> alter table hr-data set column Reason4leaving1 char(100)
I thought I knew - but I wanted to play safe. So I went to
http://mysql.com and entered alter table to the search box.
>From the results list I chose ALTER TABLE Syntax:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Here I found what I remembered:
If you want to change a column's type but not the name, CHANGE
syntax still requires two column names even if they are the same.
For example:
mysql> ALTER TABLE t1 CHANGE b b BIGINT NOT NULL;
So: you have to repeat the column name!
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php