Hi.
Usually, Any AUTO_INCREMENT field in MySql table will have always an
incrementing value.
Now Suppose I emptied the table and then inserted one record, why not this
record LAST_INSERT_ID is not '1' or '0' and why it is the lastid+1 before I
empty the table?
Can't I reset that pointer w/
On Thu, 26 Jul 2001 19:13, elias wrote:
Hi.
Usually, Any AUTO_INCREMENT field in MySql table will have always an
incrementing value.
Now Suppose I emptied the table and then inserted one record, why not
this record LAST_INSERT_ID is not '1' or '0' and why it is the lastid+1
before I empty
So sprach »elias« am 2001-07-26 um 11:43:36 +0200 :
Can't I reset that pointer w/ deleting the table and creating it again?
Yep, DELETE FROM Table instead of dropping it.
Or did you mean w/o?
ALTER TABLE Table auto_increment=234;
Alexander Skwar
--
How to quote: http://learn.to/quote
3 matches
Mail list logo