如何在与c ++连接的sql中插入数组元素？ [英] How to insert array elements in sql connecting with c++?

问题描述

在我连接到数据库后，我一定会逐个插入元素到我的表，但我不知道从数组中插入元素，vector..etc到表。
下面的查询是我试过，但没有对表的影响。

After my connection to database, I surely insert elements to my table one by one, but I do not have any idea about inserting elements from an array, vector..etc to tables. Following query is that I tried, but no effects on table.

mysql_query(connection,"insert into mytable (id) values(arr[0])");  

推荐答案

C / C ++不会将值插入字符串像大多数脚本语言一样。您必须使用字符串操作来构建查询字符串，例如（在伪代码中）：

C/C++ don't interpolate values into a string as most scripting languages do. You'll have to use string operations to build the query string, e.g. (in pseudo-code):

str = "insert into mytable(id) values (" + arr[0] + ")";

。 C绝对没有办法知道在该查询字符串中的 arr [0] 应该被当作数组引用，而不仅仅是看起来像一个的纯文本。因此，必须自己构建字符串。

instead. C has absolutely no way of knowing that arr[0] in that query string should be treated as an array reference, and not just plain text that happens to look like one. Hence having to build the string yourself.

这篇关于如何在与c ++连接的sql中插入数组元素？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！