Multi Select Statement in MySQL

[astonmak]

Dear all,

Is MySQL support a batch select statement from the application at client side;

I've send a command from Visual Basic with 2 insert statement and put the ";" as a seperator, but return a error.

Actually, i have experienced sucessfully update from other 3rd party database management tool. Is here any tricky?

Thanks
Aston

 

[danielhozac]

You cannot have mutiple queries in a call to [tt]mysql_query()[/tt]. The semicolon only works in the client application, which breaks up the queries and calls [tt]mysql_query()[/tt] multiple times. //Daniel

 

[astonmak]

Hi Daniel,

Thanks for your help.

But actually i was using VB adodb to issue the mutiple select statement, is it also doesn't work?

And I stick to it because of I'm thinking this is the most easiest way to keep the data integrate. Is there any way to doing this except using transaction method? Cause i don't know how to call MySQL transaction funcion through Visual Basic.

Thanks alot
Aston