How to insert array elements in sql connecting with c++?

Question

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])");

"insert into mytable (id) values(arr[0])" -> This is a constant string, nothing will be replace for arr[0] from your array/vector — DumbCoder
– DumbCoder, Commented Jan 17, 2012 at 16:34

Marc B · Accepted Answer · 2012-01-17 16:34:43Z

1

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] + ")";

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.

answered Jan 17, 2012 at 16:34

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert array elements in sql connecting with c++?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related