Hello.
Not enough information to make a conclusion. Please, send us information
about MySQL and operating system versions. Output of show create table
statement on your tables. Could you make a reproducable test case?
leegold [EMAIL PROTECTED] wrote:
I have two different databases they
On Mon, 24 Jan 2005 12:34:38 +0200, Gleb Paharenko
[EMAIL PROTECTED] said:
Hello.
Not enough information to make a conclusion. Please, send us information
about MySQL and operating system versions. Output of show create table
statement on your tables. Could you make a reproducable test
Oh, myqldump automatically records the current auto-increment when it
dumps in the .sql file...
That explains it...
On Mon, 24 Jan 2005 17:10:11 -0500, leegold [EMAIL PROTECTED]
said:
On Mon, 24 Jan 2005 12:34:38 +0200, Gleb Paharenko
[EMAIL PROTECTED] said:
Hello.
Not enough
Now I'm confused the auto-increment number reverted back to one (1)
after I truncated the tables in one of the DB's. I suppose as long as
the number is unique within the objects I'm making selections,
updates...ect in - who cares.
On Sun, 23 Jan 2005 02:18:33 -0500, leegold [EMAIL PROTECTED]
: Adolfo Bello [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 7:15 PM
Subject: RE: auto increment question
It sounds to me that a trigger would help, but mysql doesn't has them
yet.
Adolfo
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED
Kevin,
I have a table with an ID column and a viewed column. I would like the
viewed column to increment by one each time the row is updated.
Stats
===
ID
views
UPDATE Stats SET Views = Views + 1 WHERE ID = (selected row)
Or is there more behind this question?
Regards,
--
Stefan
At 15:28 -0800 1/3/03, Kevin wrote:
Hello,
I have a table with an ID column and a viewed column. I would like the
viewed column to increment by one each time the row is updated.
Stats
===
ID
views
is this possible?
Sure. Since you're updating the row anyway, set the column value to
one
It sounds to me that a trigger would help, but mysql doesn't has them
yet.
Adolfo
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 8:04 PM
To: Kevin; [EMAIL PROTECTED]
Subject: Re: auto increment question
At 15:28 -0800 1/3/03
It sounds to me that a trigger would help, but mysql doesn't has them
yet.
Adolfo
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 8:04 PM
To: Kevin; [EMAIL PROTECTED]
Subject: Re: auto increment question
At 15:28 -0800 1/3/03