Hi,
I can do:
where word in('one','two','three')
and I can also do:
where word like 'thr%'
Is there a way of combining these 2 ways?
I want to select something like:
where word like 'on%' or word like 'tw%' or word like 'thr%'
but using a single expression, without or.
Is it possible to
I have a problem related with 2 mysql database synchronization. We are using
a 256kbps internet at our mfg. site and a 2mbps internet connection at our
HO. We are using MySQL5.0.45 for our ERP application. We want to work from
both locations at a time through ERP software. For this we are trying
Thank you for your response. I am using InnoDB (picked that out of the docs).
Does that mean what I did should have worked? I should not have had 2 rows in
that table after running the commands?
Thanks again...
I would like to wrap my updates top MySQL in transactions.
Use InnoDB tables.
I apologize if you saw this on the MySQL Forums but I have not gotten a
response... Thanks for your help...
I know this is probably a stupid question but I could use a nudge in the right
direction.
I would like to wrap my updates top MySQL in transactions. I am using ODBC as
my means of
hi guys - i figured this out, turned out someone or something had applied an
overly strict iptables rule
best,
paul
On 1/25/08, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
You didn't say what your command line looked like - e.g., whether you
were selecting a db as part of it.
Assuming you
hey guys - overnight our sql server apparantly got hit hard, and started
dropping connections
it was restarted and now this morning even though its showing 0 processes
running, seems
completely healthy on all tests, mysqld restarted with no sign of problems -
none of the
web servers can connect to
Does that mean what I did should have worked?
I'd want to know (i) the result of executing those cmds in a mysql
client, and (ii) what sqlresult acountinfo contain after each cmd.
PB
[EMAIL PROTECTED] wrote:
Thank you for your response. I am using InnoDB (picked that out of the docs).
Cool it's good to know thank you.
On 25/01/2008, Jay Pipes [EMAIL PROTECTED] wrote:
Nope, no difference, AFAIK.
Alex K wrote:
Any ideas pertaining this newbie question?
Thank you so much,
Hi Guys,
Is there a performance hit when joining across multiple databases as
opposed to
I would like to wrap my updates top MySQL in transactions.
Use InnoDB tables.
PB
[EMAIL PROTECTED] wrote:
I apologize if you saw this on the MySQL Forums but I have not gotten a
response... Thanks for your help...
I know this is probably a stupid question but I could use a nudge in the