不知道为什么下面的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");