re: What is wrong with this Alter statement?

2002-12-16 Thread Victoria Reznichenko
On Tuesday 17 December 2002 09:43, C. Reeve wrote: From the MySQL Manual: ALTER TABLE tbl_name MODIFY [COLUMN] create_definition [FIRST | AFTER column_name] I have also tried CHANGE instead of MODIFY. My Statement: alter table manager change column w1 decimal(8,2) not null after moves;

Re: What is wrong with this Alter statement?

2002-12-16 Thread Paul DuBois
At 2:43 -0500 12/17/02, C. Reeve wrote: From the MySQL Manual: ALTER TABLE tbl_name MODIFY [COLUMN] create_definition [FIRST | AFTER column_name] I have also tried CHANGE instead of MODIFY. My Statement: alter table manager change column w1 decimal(8,2) not null after moves; The problem is

What is wrong with this Alter statement?

2002-12-15 Thread C. Reeve
From the MySQL Manual: ALTER TABLE tbl_name MODIFY [COLUMN] create_definition [FIRST | AFTER column_name] I have also tried CHANGE instead of MODIFY. My Statement: alter table manager change column w1 decimal(8,2) not null after moves; The problem is the AFTER statement, if I omit it I have