不知道为什么下面的mysql运行说有语法错误，怎么看也看不出来

CREATE TABLE IF NOT EXISTS `bioRS`(    
`id` INT UNSIGNED AUTO_INCREMENT,    
`user` VARCHAR(20) NOT NULL,    
`location` VARCHAR(10) NOT NULL,    
`la` FLOAT NOT NULL,    
`long` FLOAT NOT NULL,    
`gvi` FLOAT NOT NULL,    
`biodiversity` FLOAT NOT NULL,    
`picture` VARCHAR(30) NOT NULL,    
`time` VARCHAR(30) NOT NULL,    
PRIMARY KEY ( `id` )    
)ENGINE=InnoDB DEFAULT CHARSET=utf8;    
INSERT INTO bioRS    
(user, location, la, long, gvi, biodiversity, picture, time)    
VALUES    
("root","TM",30.3369240833333,119.433672027777,0.0662138438624312,-1,"TM__1.JPG","2020:11:08 09:33:32");

解决:

MySQL 内置字段的原因

把long改下,或者吧long加上``符号

INSERT INTO bioRS
(user, location, la, `long`, gvi, biodiversity, picture, time)
VALUES
("root","TM",30.3369240833333,119.433672027777,0.0662138438624312,-1,"TM__1.JPG","2020:11:08 09:33:32");