HI everybody. I saw, when i delete all records from the table where id is primary key and auto_increment, the first number for id is'nt 1 but next in a row (the last was 5 the next will be 6).
Can i change this behavior ? Mybe in file my.ini ? The goal is, that when i delete all records from the table the id field begin with 1, when i insert a record. I use 3.23.43-max on win98, the table is myisam type. regards. I. Piasecki. --------------------------------------------------------------------- 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