too, for efficiency.
Best of luck,
-Shane
- Original Message -
From: "Phill Gillespie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 15, 2003 3:54 PM
Subject: Re: Simple MySQL help needed...
> Shane Bryldt wrote:
>
> >I think t
SET cardnumb=%d WHERE newphoto=1 and
tbprinted=1;", iHighNum);
This in effect leaves any processing possible to the client side.
Hope that helps,
-Shane
- Original Message -
From: "Phill Gillespie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 1
-
From: "Phill Gillespie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 15, 2003 1:53 PM
Subject: Simple MySQL help needed...
> Hi *
>
> I'm running MySQl 3.23 and I'm trying to run a very simple command that
> basically finds the highest num
Hi *
I'm running MySQl 3.23 and I'm trying to run a very simple command that
basically finds the highest number in a column and then for all matching
rows sets their card number to be +1. The code looks
like this:
#cardnumb is actually a string of the form SNx so set @high=x as
a nu
