mysql插入问题 [英] mysql Insert Question

问题描述

我相信此C ++代码段的语法是错误的.任何帮助表示赞赏.谢谢

I believe the syntax is wrong on this c++ snippet. Any help appreciated. Thanks

mysql_insert(conn, "INSERT INTO tblURLAccess (IP,Count) VALUES (''192.168.1.1'',''1''");

推荐答案

您在查询语句的末尾缺少).
mysql_insert(conn, "INSERT INTO tblURLAccess (IP,Count) VALUES (''192.168.1.1'',''1'')");

You have a missing ) at the end of the query statement.
mysql_insert(conn, "INSERT INTO tblURLAccess (IP,Count) VALUES (''192.168.1.1'',''1'')");

习惯养成在MySQL查询浏览器中尝试SQL进行测试以消除这种情况的任何SQL问题的习惯.

It would not hurt to get into the habit of trying the SQL in the MySQL query browser to test it and eliminate any SQL problems from the situation.

这篇关于mysql插入问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！