set @my_query='SELECT * FROM t1 WHERE a=@var'; set @var=2;execute @my_query;
The trick, IMO, is to do all that in one trip to the server. That is one of the problems with prepared statements now. Single use statements require to trips to the server.
Brian. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
