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
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 reproducabl
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 database
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]>
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,
--
Stef
sage -
From: "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
>
> >
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
>
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, 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 m
