Re: adding set field
Available news archives: comp.lang.tcl - comp.lang.python - comp.security.firewalls - sci.crypt - comp.lang.php - comp.lang.javascript
Google
 
Web news.hping.org


comp.lang.php archive

Re: adding set field

From: Gordon Burditt <gordonb.ejory@burditt.org>
Date: Mon Sep 26 2005 - 23:23:53 CEST

> What is missing form this SQL-query:
>
>ALTER TABLE `logins` ADD `categories` SET

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
Received on Tue Oct 18 02:28:20 2005