Re: execute multiple queries with mysql c++ connector

On 25.02.2017 06:14, kushal bhattacharya wrote:
> error message is error near the part where ';' is provided
> and its saying to refer to the manual of mysql but when i run it
> on phpmyadmin it runs propewrly without showing any arror

Then *why* can't you just copy and paste your query and the error message?

That error you made is a simple one: there does not belong a semicolon (";") at the end of the query - not if you send it through any connector. The ; is only for the command line client (mysql or phpAdmin) to determine where the query actually ends. This is necessary because a query can span multiple lines. It's however not part of the query and is thus not sent to the MySQL server. Received on Sun Feb 26 2017 - 10:14:30 CET