1: Your no more of an idiot than the rest of us. You just weren't around to
see my newbie phase. Doesn't mean it didn't happen. :)
2: You need to select all your records into a temp table, drop your existing
table re-create it with the proper structure and then insert your records
back into it.
HTH,
Cal
http://www.calevans.com
-----Original Message-----
From: Steven Fruchter [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 09, 2001 6:18 PM
To: Mysql
Subject: one more small question
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
---------------------------------------------------------------------
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