List:General Discussion« Previous MessageNext Message »
From:Daniele Colajacomo Date:April 2 1999 10:16pm
Subject:Nevermind: [Syntax for SET types]
View as plain text  
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'...:))


-------- 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,

Please check ""
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.
Nevermind: [Syntax for SET types]Daniele Colajacomo3 Apr