Hi Nicole, You need to change the columns and alter the specifications (or at least that is how I do it)
ALTER table table_name CHANGE column column_name create_definition SO it would look like this ALTER table balh chage column foo foo int(5)unsigned I hope that helps. -Flint -----Original Message----- From: Nicole Amashta [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: [PHP-WIN] [N-PHP-R] Help with MySQL I know this is not MySQL, so that's why I put the [N-PHP-R] in the subject (means Non-PHP-Related) But, my problem is this. I have a table in MySQL. One of the fields (not the primary key), has a unique constraint on it. I need to remove this unique constraint, but I can't figure out how. I dn't see this in the MySQL docs. Does anyone know how to remove uniquness from a field? Thanks, -- Nicole Amashta Web Applications Developer www.aeontrek.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
