Hi,
On Jan 28, 2008 3:29 PM, Dean Karres <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I know that someone is going to say, "go ask the perl module guys" and
> I will but they are likely to say, "go ask the MySQL guys". I'll be
> asking in both groups.
>
> I am installing a script on a brand new RedHat, F
n
- Original Message -
From: "Dean Karres" <[EMAIL PROTECTED]>
To:
Sent: Monday, January 28, 2008 10:29 PM
Subject: MySQL, perl, last_insert_id() question
Hi,
I know that someone is going to say, "go ask the perl module guys" and
I will but they are likely
Hi,
I know that someone is going to say, "go ask the perl module guys" and
I will but they are likely to say, "go ask the MySQL guys". I'll be
asking in both groups.
I am installing a script on a brand new RedHat, Fedora Core 7 (x86_64)
box that is running MySQL 5.0.45 (rpm install). I also hav
Hi Sean,
> "If expr is given as an arguement to LAST_INSERT_ID(), the value of the
> arguement is returned by the function, is set as the next value to be
> returned by LAST_INSERT_ID(), and is used as the next AUTO_INCREMENT
> value"
I don't think this entire statement is correct. The onlin
I've read a bit about using LAST_INSERT_ID(expr)
to set the next auto_increment value.
my question is, if i have 2 tables, like follows
CREATE TABLE A (
id int not null auto_increment primary key,
...
)type=MyISAM;
CREATE TABLE B (
id int not null auto_increment primary key,
...
)type=MyISAM;
