MFC 多条数据插入Mysql数据库指定的表中插入失败

 插入数据时格式为

 INSERT  INTO tableName (key,hole_id,x,y,z)VALUES("4","A1","10","10","12");   

会提示错误,检查不出错误原因.

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 'key,hole_id,x,y,z)VALUES("4","A1","10","10","12")' at line 1

经过多次尝试在字段名称前面加入表的名称就可成功插入；

如下

 INSERT  INTO tableName (tableName.key,tableName.hole_id,tableName.x,tableName.y,tableName.z)VALUES("4","A1","10","10","12");   

Query OK, 1 row affected (0.04 sec)