Create Syntax (easy)

2009-09-29 Thread Victor Subervi 
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

Re: Create Syntax (easy)

2009-09-29 Thread David Giragosian 
On Tue, Sep 29, 2009 at 11:09 AM, Victor Subervi victorsube...@gmail.comwrote:

 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)

2009-09-29 Thread Victor Subervi 
That's it! Thanks,
V

On Tue, Sep 29, 2009 at 12:13 PM, David Giragosian dgiragos...@gmail.comwrote:

 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