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

查看全部
dongqiao9015
dongqiao9015
2014/11/11 06:28
  • php
  • mysql
  • 点赞
  • 收藏
  • 回答
    私信
满意答案
查看全部

4个回复