dongqiao9015
dongqiao9015
2014-11-11 06:28

MySQL - 插入语句是正确的,但它仍然是错误

  • php
  • mysql

I'm a bit stumped.

I have a SQL insert statement which is as follows:

INSERT INTO region_points (suburb_id, lat, long) VALUES ('1','-33.8737357','150.8697605')

I don't see anything at all wrong with the statement, but when i run it, I'm getting:

#1064 - 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 'long) VALUES ('1','-33.8737357','150.8697605')' at line 1

Any help with this would be greatly appreciated.

Cheers

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

4条回答