dongqiao9015
2014-11-11 06:28MySQL - 插入语句是正确的,但它仍然是错误
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条回答
为你推荐
- MySQL - 插入语句是正确的,但它仍然是错误
- mysql
- php
- 4个回答
- springboot jpa生成sql语句时间格式不正确?
- spring
- java
- 2个回答
- 用hibernate等实现:从一数据库复制一条记录,然后修改该记录的某一列,再插入原数据库
- 数据库
- struts
- hibernate
- mysql
- 2个回答
- node.js的mysql模块query方法里的字符串拼接问题
- mysql
- query
- node.js
- 1个回答