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).
D
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 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 righ
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 databa
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 commun
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
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
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 to
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
