How to execute multiple SQL instructions in one step

[Attila]

Hi Everyone,

I am using the following to try and execute a lock on table and then in
update:

const char* sql = "LOCK TABLES MyTable WRITE;UPDATE MyTable SET status=
'STARTED' WHERE status_id= '7' AND address = 167473977; UNLOCK TABLES;";

// m_pConnection is a mysqlpp::Connection
mysqlpp::Query query = m_pConnection->query(sql);
mysqlpp::StoreQueryResult storeResult(query.store());

However this gives me a syntax error. Is there any way to accomplish the
above in one call?

Thank you,

-- 
A