On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi <victorsube...@gmail.com>wrote:
> Hi;
> Please give me the syntax below such that I can force the insert statements
> to use only selected values ("item1", "item2", "item3"):
>
> create table (field SOMETHING_HERE item1 item2 item3,
> ...
> )
>
> TIA,
> Victor
>
CREATE TABLE set_test(
rowid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
myset SET('Travel','Sports','Dancing','Fine Dining')
);
From: http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html
David
--
There is more hunger for love and appreciation in this world than for
bread.- Mother Teresa
