adding set field

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
  What is missing form this SQL-query:

ALTER TABLE `logins` ADD `categories` SET

MySQL said: Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that  
corresponds to your MySQL server version for the right syntax to use  
near '' at line 1

Re: adding set field

Quoted text here. Click to load it

The list of things that it's a set of:

ALTER TABLE `logins` ADD `categories`  
SET ('spammer', 'murderer', 'kidnapper', 'thief', 'top-poster', 'terrorist');

Also, check that this is available on your version of MySQL.

                        Gordon L. Burditt

Re: adding set field

Gordon Burditt wrote:
Quoted text here. Click to load it

It's available, I guess what has me buggered is that  phpMyAdmin seems  
like it will allow the interface to do this, but there's no way to add  
the SET values.

Re: adding set field

the proper syntax for altering the table is :
ALTER TABLE logins ADD (categories varchar(20))
i think it will surely disappeared ur problem.
and if someone get right syntax from that which includes SET ,,,,,,so
plz inform me.......THANX ...  :-)

Site Timeline