subject:"Re\: Help With Default Value"

Re: Help With Default Value

2003-03-31 Thread gerald_clark

ot;MySQL List" <[EMAIL PROTECTED]> To: "Bhavin Vyas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, March 30, 2003 9:44 PM Subject: Re: Help With Default Value Ok, how do I get the MAX(id)? Thanks, Richard - Original Message - From: "Bhavin

Re: Help With Default Value

2003-03-30 Thread MySQL List

March 30, 2003 9:44 PM Subject: Re: Help With Default Value > Ok, how do I get the MAX(id)? > > Thanks, > Richard > > > - Original Message - > From: "Bhavin Vyas" <[EMAIL PROTECTED]> > To: "MySQL List" <[EMAIL PROTECTED]>

Re: Help With Default Value

2003-03-30 Thread MySQL List

Ok, how do I get the MAX(id)? Thanks, Richard - Original Message - From: "Bhavin Vyas" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, March 30, 2003 7:59 PM Subject: Re: Help With Default Value >

Re: Help With Default Value

2003-03-30 Thread Bhavin Vyas

First option, I don't think, is possible. Reg. 2, You can get MAX(Id) before inserting, increment it by 1 in your script and then Insert 'gc' as the invoice_id value. Bhavin. - Original Message - From: "MySQL List" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 30, 2003 7: