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-Related)
>
>But, my problem is this.
>
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
