mysql错误1064 42000_mysql 错误 ERROR 1064(42000) ，一上午不知是哪儿错了

ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'AFTERmodel,MODIFYCOLUMNyearSIXTH,CHANGECOLU...

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER model,

MODIFY COLUMN year SIXTH,

CHANGE COLUMN howmuch price DECIMAL(7,2),' at line 6

CREATE TABLE `hooptie` (

`color` varchar(20) default NULL,

`year` varchar(4) default NULL,

`make` varchar(20) default NULL,

`mo` varchar(20) default NULL,

`howmuch` float(10,3) default NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `hooptie` (`color`,`year`,`make`,`mo`,`howmuch`) VALUES ('silver','1998','Porsche','Boxter','17992.539');

INSERT INTO `hooptie` (`color`,`year`,`make`,`mo`,`howmuch`) VALUES (NULL,'2000','Jaguar','XJ','15995.000');

INSERT INTO `hooptie` (`color`,`year`,`make`,`mo`,`howmuch`) VALUES ('red','2002','Cadillac','Escalade','40215.898');

ALTER TABLE hooptie

RENAME TO car_table,

ADD COLUMN car_id INT NOT NULL AUTO_INCREMENT FIRST,

ADD COLUMN VIN VARCHAR(17) AFTER car_id,

CHANGE COLUMN mo model VARCHAR(20),

MODIFY COLUMN color AFTER model,

MODIFY COLUMN year SIXTH,

CHANGE COLUMN howmuch price DECIMAL(7,2),

ADD PRIMARY KEY (car_id);

前面都没有问题，在输入ALTER这段命令后就出现了错误提示

展开