我想在下表中插入一个新行:
+-------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| index | bigint(20) unsigned | NO | PRI | NULL | |
| exports_fields_id | bigint(20) unsigned | NO | PRI | NULL | |
| exports_id | bigint(20) unsigned | NO | MUL | NULL | |
+-------------------+---------------------+------+-----+---------+-------+
为此我尝试了以下sql语句:
INSERT INTO 'exports_has_export_fields' ('index', 'exports_fields_id', 'exports_id') VALUES (0, 78, 3);
但后来我收到以下错误:
ERROR 1064(42000):您的SQL语法有错误;查看与您的MySQL服务器版本对应的手册,以便在第1行''exports_has_export_fields'('index','exports_fields_id','exports_id')附近使用正确的语法`VALUES'