Hi,
I'm new to MySQL and at this point, I'm just trying to insert rows
of data into a table.
When I insert a row of data that includes a field of type "set"
(corresponding to an HTML set of checkbox answers), only the first
item in the list gets inserted into the row.
For example, I have a table where one column, called "subject", is
of type "set". During one INSERT, the field "subject" corresponded
to the values "family, money". After I did the INSERT, the only thing
that showed up in the "subjects" field was "family". If I did it again
with a different list as values (eg, "jobs, school, parents"), only
"jobs" would show up in the table.
Here's the syntax:
INSERT into my_table (name, subjects) VALUES ("Joyce", "family, money")
Or, using a command line interface:
mysql> insert
-> into my_table
-> (name, subjects)
-> VALUES
-> ("Joyce", "family, money")
-> ;
The insert goes fine, but in the subjects column, only "family" is in
the field.
Everything else in the row gets into the table with no problems. And
there is no error message - as far as the MySQL server is concerned,
everything went fine.
I've looked at different doc sites about MySQL to see if you have to
format set data differently from other field types during INSERT, but
have found nothing.
Any suggestions??
Thanks,
J. Wermont
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
