While I am trying to tướng insert a row to tướng my table, I'm getting the following errors:
ERROR 1064 (42000): You have an error in your SQL syntax; kiểm tra the manual that
corresponds to tướng your MySQL server version for the right syntax to tướng use near ''filename')
VALUES ('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','sant' at line 1
please help má out.
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 phối (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; kiểm tra the manual that
corresponds to tướng your MySQL server version for the right syntax to tướng use near ''filename')
VALUES ('san', 'ss', 1, 1, 1, 1, 2, 1, 1, 'sment', 'notes','sant' at line 1