Dobrư den,
sexta-feira, 25 de outubro de 2002, 14:26:05, napsal jste:
CB> sql, query (*sigh*, I hate this filter)
CB> I have an auto_increment key set up on my InnoDB table.
CB> Whenever I delete all the records, the number isn't reset.
CB> However, for my ISAM tables, whenever I delete all the
CB> records, the auto_increment number is reset.
CB> Is there a reason for this in InnoDB? Is there a way that I
CB> can reset the auto_increment number when all the records
CB> are deleted? I have a temporary table that has records
CB> added and deleted all the time. I wouldn't want the record
CB> number to eventually reach the ceiling for the datatype of
CB> the field.
CB> Any insight would be greatly appreciated.
CB> Chris
try exec this query:
alter table <TABLE_NAME> auto_increment = 0;
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--
$ look into "my eyes"
look: cannot open my eyes
-------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
