Hi,
I was the idiot who had it set to tinyint. But now i want to change the
column id to int... so i typed this and got an error:
mysql> alter table custinfo change id id int NOT NULL AUTO_INCREMENT;
ERROR 1062: Duplicate entry '1' for key 1
What do i do to change it from tinyint to int...and what the hell there is
only one id 1 as i can see? how do i correct this? i tried isamchk -r
then -R and i only see one 1? and when i do a select * from custinfo where
id=1; it only shows 1 listing... please help?
Steven Fruchter
Chief Technology Officer
SMR Studios, Inc.
[EMAIL PROTECTED]
http://www.smrstudios.com
---------------------------------------------------------------------
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