From: Daniele Colajacomo
Date: April 2 1999 10:16pm
Subject: Nevermind: [Syntax for SET types]
List-Archive: http://lists.mysql.com/mysql/1350
Message-Id: <370541C1.37020B7@3dsite.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Posting to a list is the best way to find answers... often they
pop up immediately after hitting the 'send' button.

If I use 'First,Second' it works.
(but I'm still hoping someone will help with my previous
message titled 'Missing Documentation'...:))

thanks,
dani


-------- Original Message --------
Subject: Syntax for SET types
Date: Fri, 02 Apr 1999 14:12:50 -0800
From: Daniele Colajacomo <dani@stripped>
Organization: 3DSite, Inc.
To: mysql@stripped


(I hate learning new languages without proper documentation!)

the docs explain:

CREATE TABLE mytable ( choices SET('First','Second') ) ;


fine - nowhere it mentions how you can INSERT though.
What do you do?  Let's say I want to set the "choices"
to both First and Second.

INSERT INTO mytable ...

This is surely so basic that the docs don't even bother...
(p.s. I want to do this with placeholders in DBI:
$sth = $dbh->prepare("INSERT INTO mytable (choices) values (?)");
$sth->execute(.....) <- ?
)

thanks for any help,
dani

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"
before
posting. To request this thread, e-mail mysql-thread1349@stripped

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.