Re: auto_increment update
On Thu, Jun 14, 2001 at 07:30:01PM -0500, Paul DuBois wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* At 1:36 AM +0200 6/15/01, Sven Huster wrote: Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. Well, that's what's supposed to happen if you have a primary key or unique key on multiple columns where the last column is an AUTO_INCREMENT value. If you want your AUTO_INCREMENT column to have unique values for each row, then you could drop that index and set up a PRIMARY KEY on just the AUTO_INCREMENT column. Actually, I'm not sure I understand what you want to do, so I'm just guessing. If that doesn't answer your question, please clarify. Hi i want to fix the auto_increment col to have unique entries, but if i drop the index there are double entries in for the col, so i dont think it works just by dropping the key. there is data in the table that i dont want to loose. regards sven - 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
Re: auto_increment update
At 10:39 AM +0200 6/15/01, Sven Huster wrote: On Thu, Jun 14, 2001 at 07:30:01PM -0500, Paul DuBois wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* At 1:36 AM +0200 6/15/01, Sven Huster wrote: Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. Well, that's what's supposed to happen if you have a primary key or unique key on multiple columns where the last column is an AUTO_INCREMENT value. If you want your AUTO_INCREMENT column to have unique values for each row, then you could drop that index and set up a PRIMARY KEY on just the AUTO_INCREMENT column. Actually, I'm not sure I understand what you want to do, so I'm just guessing. If that doesn't answer your question, please clarify. Hi i want to fix the auto_increment col to have unique entries, but if i drop the index there are double entries in for the col, so i dont think it works just by dropping the key. there is data in the table that i dont want to loose. Drop the AUTO_INCREMENT column, than add it back as an AUTO_INCREMENT PRIMARY KEY. MySQL will number the columns values uniquely for you. regards sven -- Paul DuBois, [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
auto_increment update
Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. thanks regards Sven Huster - 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
Re: auto_increment update
At 1:36 AM +0200 6/15/01, Sven Huster wrote: Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized that most rows contain 1 cause the primary key was set on the auto_increment col + another one. so mysql only creates a entry 1 if the other field was equal to another row. Well, that's what's supposed to happen if you have a primary key or unique key on multiple columns where the last column is an AUTO_INCREMENT value. If you want your AUTO_INCREMENT column to have unique values for each row, then you could drop that index and set up a PRIMARY KEY on just the AUTO_INCREMENT column. Actually, I'm not sure I understand what you want to do, so I'm just guessing. If that doesn't answer your question, please clarify. thanks regards Sven Huster -- Paul DuBois, [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