RE: [OT] mod_perl and last_insert_id() (Was: sequence and nextval)

2001-12-13 Thread Carsten H. Pedersen
> If running mod_perl does this stay true??? > > Isn't mod_perl using an already opened connection to do subsequent > manipulations? > Well, I assume you're not going to call last_insert_id() unless you have just inserted something into a table, thus updating the value for that particular conne

Re: [OT] mod_perl and last_insert_id() (Was: sequence and nextval)

2001-12-13 Thread sherzodR
> > is what I use EM: > > EM: > > M EM: > > EM: > > -Original Message- EM: > > From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]] EM: > > Sent: 13 December 2001 15:41 EM: > > To: [EMAIL PROTECTED] EM: > &

Re: sequence and nextval

2001-12-13 Thread David Turner
s sadly lacking in Oracle (IMHO). > > M > > -Original Message- > From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]] > Sent: 13 December 2001 17:25 > To: [EMAIL PROTECTED] > Subject: SV: sequence and nextval > > > Thanks, but how secure is this. Is it possible

[OT] mod_perl and last_insert_id() (Was: sequence and nextval)

2001-12-13 Thread Etienne Marcotte
nce ( nextval int(10) not null default '0' > > auto_increment ) ; > > > > insert into MySequence values (''); > > select LAST_INSERT_ID(); > > > > is what I use > > > > M > > > > -Original Message- &

RE: sequence and nextval

2001-12-13 Thread Matthew Smith
]] Sent: 13 December 2001 17:25 To: [EMAIL PROTECTED] Subject: SV: sequence and nextval Thanks, but how secure is this. Is it possible for two computers to do the "select" at the same time, i.e. get the new incremented value? Computer one insert, computer two insert, computer one select, co

RE: sequence and nextval

2001-12-13 Thread Michael Migal
You can lock the table when you insert. mike -Original Message- From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 9:25 AM To: [EMAIL PROTECTED] Subject: SV: sequence and nextval Thanks, but how secure is this. Is it possible for two computers to do

RE: sequence and nextval

2001-12-13 Thread Carsten H. Pedersen
x27;0' > auto_increment ) ; > > insert into MySequence values (''); > select LAST_INSERT_ID(); > > is what I use > > M > > -Original Message- > From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]] > Sent: 13 December 2001 15:41 > To: [E

SV: sequence and nextval

2001-12-13 Thread Henrik Erlandsson
values (''); select LAST_INSERT_ID(); is what I use M -Original Message- From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]] Sent: 13 December 2001 15:41 To: [EMAIL PROTECTED] Subject: sequence and nextval Does the above functions exist in MySQL? If not, when do you think it's go

RE: sequence and nextval

2001-12-13 Thread Michael Migal
It depends what you need to do. For unique keys, I usually use AUTO_INCREMENT feature. mike -Original Message- From: Henrik Erlandsson [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 7:41 AM To: [EMAIL PROTECTED] Subject: sequence and nextval Does the above functions

sequence and nextval

2001-12-13 Thread Henrik Erlandsson
Does the above functions exist in MySQL? If not, when do you think it's going to be implemented and how can I simulate nextval the easiest way? / Thanks Henrik - Before posting, please check: http://www.mysql.com/manual.php