What does passing a parameter to where look like in C++/MySQL?

Question

MySQL

Hello!

I want to write a query to the database through the for construct.
Something like this:

for (int i = 0; i < 10; i+)
{
Object.ExecuteQuery("select ip, prefix from server where id = i");
}

Of course, this construction will not work. How to correctly pass the value of i to where?

Answer 1

Look at the prepareStatement method:

  pstmt = con->prepareStatement("INSERT INTO test(id) VALUES (?)");
  for (int i = 1; i <= 10; i++) {
    pstmt->setInt(1, i);
    pstmt->executeUpdate();
  }
  delete pstmt;