Hi, all,
In the C API, we can call mysql_query("select 1; select 2");
which just send the command once to the server, and server
return two result sets, So i want to know if there is a command in the
mysqltest framework to do the job?
I want to write a test case like that.
Thank you for your repl
The AND in your UPDATE clause makes this a logical operator instead
of being a SQL keyword.
Your syntax is wrong:
UPDATE ...
SET mycol = value,
mycol2 = value
[WHERE ... ]
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Se
Hi.
mysql> describe unions_data;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-++
| ID | int(11) | NO | PRI | NULL| au
- Original Message -
> From: "Martin Gainty"
> Subject: Proxy / connected failover question
> > >> I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck
> > >> with one shitty application that utterly breaks whenever the database
> > >> goes
> > >> away unexpectedly. I c
> CC: vegiv...@tuxera.be; mysql@lists.mysql.com
> From: wagnerbianch...@gmail.com
> Subject: Re: Proxy / connected failover question
> Date: Wed, 9 Jul 2014 08:31:05 -0300
> To: walterh...@olindata.com
>
> I like HAProxy as well as it simplifies many of the things you seem to be
> looking for.
I like HAProxy as well as it simplifies many of the things you seem to be
looking for.
--
Wagner Bianchi
Mobile: +55.31.8654.9510
> Em 09/07/2014, às 07:48, "Heck, Walter" escreveu:
>
> Johan,
>
> I don't think there's any need for the heavyness (and ugliness ;) ) of
> MySQL Proxy. We're usin
Johan,
I don't think there's any need for the heavyness (and ugliness ;) ) of
MySQL Proxy. We're using haproxy for a similar setup (just with galera
behind it, but that shouldn't really matter. Have a look at this blog post
that explains most of it:
http://www.olindata.com/blog/2014/04/managing-pe
Hi Johan,
I wanted to love mysql-proxy for so many years, so I understand you :)
> I have two main questions:
> * am I remembering right that MySQL Proxy provides transparent failover ?
>
You need to use/create a lua failover script, I've never seen or tried one.
What kept me from investing too
Hullo peoples,
I'm not usually an advocate of MySQL Proxy and the like, but I'm stuck with one
shitty application that utterly breaks whenever the database goes away
unexpectedly. I can't change the application itself, so I find myself looking
for options that allow the heathen contraption to
