Oh yeah, and to drop the index, I just did this:
alter table ftp drop index username
I don't ever remember making an index called username, but perhaps I did.
Either way, it was a unique index against the login. I don't want to have
unique logins because this table holds info about ftp from diff
OK, I figured it out:
if I do a "show index from ftp", it will tell me all the indexes on that
table.
I dropped the index that was against that field and voila! No more unique
constraint. :)
Thanks guys!
Nix0r
www.aeontrek.com
"B.A.T. Svensson" <[EMAIL PROTECTED]> wrote in message
27E647E5629E
>> >ALTER table balh chage column foo foo int(5)unsigned
>>
>> Does the key word CHANGE COLUMN really exists with in MySQL?? That would
be
>> amazing to be ale to change the domain of an attribute just like that.
>>
>Yep
>Syntax (Nicole, this is the correct syntax by the way... :-) :
>
>ALTER TA
> >ALTER table balh chage column foo foo int(5)unsigned
>
> Does the key word CHANGE COLUMN really exists with in MySQL?? That would be
> amazing to be ale to change the domain of an attribute just like that.
>
Yep
Syntax (Nicole, this is the correct syntax by the way... :-) :
ALTER TABLE table
>ALTER table balh chage column foo foo int(5)unsigned
Does the key word CHANGE COLUMN really exists with in MySQL?? That would be
amazing to be ale to change the domain of an attribute just like that.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/u
>-Original Message-
>From: Nicole Amashta
>Sent: Thursday, February 28, 2002 8:22 PM
>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-
-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
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
