mos wrote:
I've tried just about every syntax combination to try and add columns to
a table using Alter Table and I keep running into syntax errors.
Alter table MyTable add (newcol1 float after col3, newcol2 float after
col3);
or
Alter table MyTable add (newcol1 float, newcol2 float) after col3;
You must separate each action with a comma. Try this:
alter table MyTable
add newcol1 float after col3,
add newcol2 float after col3;
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
