Re: Create Syntax (easy)
That's it! Thanks, V On Tue, Sep 29, 2009 at 12:13 PM, David Giragosian wrote: > On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi >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 >
Re: Create Syntax (easy)
On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi 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
Create Syntax (easy)
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