Question

INSERT INTO语句错误

INSERT INTO 监视信息数据表 ( Time Of Track Number,Calculated Track Position Latitude(WGS-84), Calculated Track Position Longitude(WGS-84),Calculated Track Position X(Cartesian),Calculated Track Position Y(Cartesian),Calculated Track Velocity Vx(Cartesian), Calculated Track Velocity Vy(Cartesian) )VALUES('UTC时间3时3分50秒' , '北纬31.92458度' , '东经125.07989度', '310738米' , '91147米', '-107.5m/s', '-182.75m/s')错误后time被选中了，最前面那个time

Answer 1

INSERT INTO "监视信息数据表" (
"TIME OF Track NUMBER",
"Calculated Track POSITION Latitude (WGS - 84)",
"Calculated Track POSITION Longitude (WGS - 84)",
"Calculated Track POSITION X (Cartesian)",
"Calculated Track POSITION Y (Cartesian)",
"Calculated Track Velocity Vx (Cartesian)",
"Calculated Track Velocity Vy (Cartesian)"
)
VALUES
(
'UTC时间3时3分50秒',
'北纬31.92458度',
'东经125.07989度',
'310738米',
'91147米',
'-107.5m/s',
'-182.75m/s'
);
这样写试一下，在列名和表名的两边加上双引号，看看是否好用。