On Wed, Nov 13, 2002 at 05:03:38PM -0200, Silmara wrote: > I'm working with MySQL-Innodb and I have one table with primary key composed > by the 5 first fields, and I want to change this removing the primary keys > attributes and add one new field in the first position as primary key and > auto_increment. How can I do this?
I'd suggest using the ALTER TABLE command as described in the manual. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 99 days, processed 2,102,337,423 queries (244/sec. avg) --------------------------------------------------------------------- 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
