dropping uniqueness of a field

I have a unique constraint on a field that is neither a primary key
nor an index field.
How do I remove the unique constraint without deleting the field?

Thanks
John

john7 <johnmark@fastermail.com> wrote:

> I have a unique constraint on a field that is neither a primary key
> nor an index field.
> How do I remove the unique constraint without deleting the field?

ALTER TABLE table_name DROP KEY key_name;
--
Rik Wasmus
Posted on Usenet: any site claiming this as original content or me as an
contributing member is stealing content.
Ask Smart Questions: http://tinyurl.com/anel

On Mar 5, 11:14 am, Rik <luiheidsgoe...@hotmail.com> wrote:
> john7 <johnm...@fastermail.com> wrote:
> > I have a unique constraint on a field that is neither a primary key
> > nor an index field.
> > How do I remove the unique constraint without deleting the field?
>
> ALTER TABLE table_name DROP KEY key_name;
> --
> Rik Wasmus
> Posted on Usenet: any site claiming this as original content or me as an
> contributing member is stealing content.
> Ask Smart Questions:http://tinyurl.com/anel

Hi Rik,
Thanks gain for answering my questions.
I just wanted to let you know that I am using MySQL 3.3. I tested it
and it did not work. I did see a comment from someone in MySQL site
that it is has been tested for version 5.0.11 to 5.0.15.

Thanks
John

> I just wanted to let you know that I am using MySQL 3.3. I tested it
> and it did not work.

What was the error message? Please be as specific as possible
when asking questions.

You started out with:
- no MySQL version
- no record of what you've tried
- no metadata as extracted by the mysql tools

Do you think we can guess what your system looks like? :)


--
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Martijn Tonies wrote:
>> I just wanted to let you know that I am using MySQL 3.3. I tested it
>> and it did not work.
>
> What was the error message? Please be as specific as possible
> when asking questions.
>
> You started out with:
> - no MySQL version
> - no record of what you've tried
> - no metadata as extracted by the mysql tools
>
> Do you think we can guess what your system looks like? :)

Ys, it astonishes me the amount of people who think "it does not work" is a
good description of a problem!

On Mar 5, 3:04 pm, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
> Martijn Tonies wrote:
> >> I just wanted to let you know that I am using MySQL 3.3. I tested it
> >> and it did not work.
>
> > What was the error message? Please be as specific as possible
> > when asking questions.
>
> > You started out with:
> > - no MySQL version
> > - no record of what you've tried
> > - no metadata as extracted by the mysql tools
>
> > Do you think we can guess what your system looks like? :)
>
> Ys, it astonishes me the amount of people who think "it does not work" is a
> good description of a problem!

I don't think you know the answer to the question. Why would an error
message help? The question is, is it implemented in MySQL 3.3?

I forgot to put the version in the first post, but I did said the
version is 3.3 later and I said I am trying to drop uniqueness
constraint from a field. There is nothing complicated here that would
need examples and error messages. The question is can uniqueness
constraint be removed from a field in MySQL 3.3?

On Mar 5, 2:58 pm, "Martijn Tonies" <m.ton...@upscene.removethis.com>
wrote:
> > I just wanted to let you know that I am using MySQL 3.3. I tested it
> > and it did not work.
>
> What was the error message? Please be as specific as possible
> when asking questions.
>
> You started out with:
> - no MySQL version
> - no record of what you've tried
> - no metadata as extracted by the mysql tools
>
> Do you think we can guess what your system looks like? :)
>
> --
> Martijn Tonies
> Database Workbench - development tool for MySQL, and more!
> Upscene Productionshttp://www.upscene.com
> My thoughts:http://blog.upscene.com/martijn/
> Database development questions? Check the forum!http://www.databasedevelopmentforum.com

john7 wrote:
> On Mar 5, 3:04 pm, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
>> Martijn Tonies wrote:
>>>> I just wanted to let you know that I am using MySQL 3.3. I tested it
>>>> and it did not work.
>>> What was the error message? Please be as specific as possible
>>> when asking questions.
>>> You started out with:
>>> - no MySQL version
>>> - no record of what you've tried
>>> - no metadata as extracted by the mysql tools
>>> Do you think we can guess what your system looks like? :)
>> Ys, it astonishes me the amount of people who think "it does not work" is a
>> good description of a problem!
>
> I don't think you know the answer to the question. Why would an error
> message help? The question is, is it implemented in MySQL 3.3?
>

An error message helps because it tells us exactly what MySQL is
complaining about. "It doesn't work" is not a real description of the
problem.

So yes - an error message helps. If they weren't important, why would
MySQL go to the trouble of implementing them? They could just return
"it doesn't work" for any error.

And I think you're an asshole.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

On Mar 5, 7:14 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> john7 wrote:
> > On Mar 5, 3:04 pm, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
> >> Martijn Tonies wrote:
> >>>> I just wanted to let you know that I am using MySQL 3.3. I tested it
> >>>> and it did not work.
> >>> What was the error message? Please be as specific as possible
> >>> when asking questions.
> >>> You started out with:
> >>> - no MySQL version
> >>> - no record of what you've tried
> >>> - no metadata as extracted by the mysql tools
> >>> Do you think we can guess what your system looks like? :)
> >> Ys, it astonishes me the amount of people who think "it does not work" is a
> >> good description of a problem!
>
> > I don't think you know the answer to the question. Why would an error
> > message help? The question is, is it implemented in MySQL 3.3?
>
> An error message helps because it tells us exactly what MySQL is
> complaining about. "It doesn't work" is not a real description of the
> problem.
>
> So yes - an error message helps. If they weren't important, why would
> MySQL go to the trouble of implementing them? They could just return
> "it doesn't work" for any error.
>
> And I think you're an asshole.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================- Hide quoted text -
>
> - Show quoted text -

An error message helps in certain cases but not when you only want to
know if a feature is implemented in a certain version

john7 wrote:
> On Mar 5, 7:14 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> john7 wrote:
>>> On Mar 5, 3:04 pm, "Paul Lautman" <paul.laut...@btinternet.com> wrote:
>>>> Martijn Tonies wrote:
>>>>>> I just wanted to let you know that I am using MySQL 3.3. I tested it
>>>>>> and it did not work.
>>>>> What was the error message? Please be as specific as possible
>>>>> when asking questions.
>>>>> You started out with:
>>>>> - no MySQL version
>>>>> - no record of what you've tried
>>>>> - no metadata as extracted by the mysql tools
>>>>> Do you think we can guess what your system looks like? :)
>>>> Ys, it astonishes me the amount of people who think "it does not work" is a
>>>> good description of a problem!
>>> I don't think you know the answer to the question. Why would an error
>>> message help? The question is, is it implemented in MySQL 3.3?
>> An error message helps because it tells us exactly what MySQL is
>> complaining about. "It doesn't work" is not a real description of the
>> problem.
>>
>> So yes - an error message helps. If they weren't important, why would
>> MySQL go to the trouble of implementing them? They could just return
>> "it doesn't work" for any error.
>>
>> And I think you're an asshole.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================- Hide quoted text -
>>
>> - Show quoted text -
>
> An error message helps in certain cases but not when you only want to
> know if a feature is implemented in a certain version
>
>

If you want to know if a certain feature is implemented in a certain
version, check the doc at www.mysql.com. It's all in there.

If you want help with a problem, ask here. And give the error message.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================