错误1064 (42000)：您的SQL语法中有一个错误；请查看与您的MySQL服务器版本对应的手册，以了解要使用的正确语法。
错误1064 (42000)：您的SQL语法中有一个错误；请查看与您的MySQL服务器版本对应的手册，以了解要使用的正确语法。
提问于 2014-02-25 17:18:31
当我试图在我的表中插入一行时，我得到了以下错误：
ERROR 1064 (42000): 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 ''filename')
VALUES ('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','sant' at line 1请帮帮我。
mysql> desc risks;
+-----------------+--------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| status | varchar(20) | NO | | NULL | |
| subject | varchar(100) | NO | | NULL | |
| reference_id | varchar(20) | NO | | | |
| location | int(11) | NO | | NULL | |
| category | int(11) | NO | | NULL | |
| team | int(11) | NO | | NULL | |
| technology | int(11) | NO | | NULL | |
| owner | int(11) | NO | | NULL | |
| manager | int(11) | NO | | NULL | |
| assessment | longtext | NO | | NULL | |
| notes | longtext | NO | | NULL | |
| submission_date | timestamp | NO | | CURRENT_TIMESTAMP | |
| last_update | timestamp | NO | | 0000-00-00 00:00:00 | |
| review_date | timestamp | NO | | 0000-00-00 00:00:00 | |
| mitigation_id | int(11) | NO | | NULL | |
| mgmt_review | int(11) | NO | | NULL | |
| project_id | int(11) | NO | | 0 | |
| close_id | int(11) | NO | | NULL | |
| submitted_by | int(11) | NO | | 1 | |
| filename | varchar(30) | NO | | NULL | |
+-----------------+--------------+------+-----+---------------------+----------------+
21 rows in set (0.00 sec)
**mysql> INSERT INTO risks (`status`, `subject`, `reference_id`, `location`, `category`,
`team`, `technology`, `owner`, `manager`, `assessment`, `notes`,'filename') VALUES
('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','santu');**
ERROR 1064 (42000): 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 ''filename')
VALUES ('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','sant' at line 1回答 6
Stack Overflow用户
回答已采纳
发布于 2014-02-25 17:31:24
在MySQL中有两种不同类型的引号。需要使用for column names and ' for strings. Since you have used ' for the filename column the query parser got confused. Either remove the quotation marks around all column names, or change 'filename' to文件名`。那么它应该是有效的。
Stack Overflow用户
发布于 2014-02-25 17:20:41
不要将列filename引起来
mysql> INSERT INTO risks (status, subject, reference_id, location, category, team, technology, owner, manager, assessment, notes,filename)
VALUES ('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','santu');Stack Overflow用户
发布于 2021-01-18 23:15:37
将下面的代码另存为command.sql
USE restaurant
TRUNCATE `orders`;
TRUNCATE `order_items`;然后运行
mysql -u root <comands.sql> output.tab页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/22009582
复制相关文章
相似问题
腾讯云开发者
