Create table: ENUM and set : Create Table « Table Index « SQL / MySQL






  1. SQL / MySQL
  2. Table Index
  3. Create Table

Create table: ENUM and set

   
/*
mysql> Drop table Bike;

mysql> CREATE TABLE Bike
    -> (
    ->    ID SMALLINT UNSIGNED,
    ->    Model VARCHAR(40),
    ->    Color ENUM('red', 'blue', 'green', 'yellow'),
    ->    Options SET('rack', 'light', 'helmet', 'lock')
    -> );
Query OK, 0 rows affected (0.09 sec)

mysql> Describe Bike;
+---------+-------------------------------------+------+-----+---------+-------+
| Field   | Type                                | Null | Key | Default | Extra |
+---------+-------------------------------------+------+-----+---------+-------+
| ID      | smallint(5) unsigned                | YES  |     | NULL    |       |
| Model   | varchar(40)                         | YES  |     | NULL    |       |
| Color   | enum('red','blue','green','yellow') | YES  |     | NULL    |       |
| Options | set('rack','light','helmet','lock') | YES  |     | NULL    |       |
+---------+-------------------------------------+------+-----+---------+-------+

4 rows in set (0.01 sec)


*/
Drop table Bike;

CREATE TABLE Bike
(
   ID SMALLINT UNSIGNED,
   Model VARCHAR(40),
   Color ENUM('red', 'blue', 'green', 'yellow'),
   Options SET('rack', 'light', 'helmet', 'lock')
);

Describe Bike;








Related examples in the same category

1.Create Simple Tables
2.Create table: default value for column
3.Create table: small int and unsigned int
4.Create table: smallint, decimal and float
5.Create table: char, varchar
6.Create table: BLOB
7.Create table: char set and language
8.Create table: YEAR and TIMESTAMP
9.Create table: null and not null
10.Create table: not null and default value
11.Create table: default int value
12.Create table: primary key
13.Create table: primary key 2
14.Create table: two columns for primary key
15.Create table: auto increment primary key
16.Create table: REFERENCES
17.Create table: foreign key
18.Create table: engine type INNODB
19.Set average row length and max, min rows
20.Syntax for Creating Tables (CREATE TABLE)
21.Create an empty table, use a WHERE clause that is always false
22.To produce a summary that includes all hours of the day, create a reference table that lists each hour
23.Creates table-level privileges.
24.Create a copy of the product table:
25.Create a table called cust_names using the table definitions and data from the product table.
26.CREATE TABLE IF NOT EXISTS
27.CREATE TABLE TEAMS_COPY1 LIKE TEAMS
28.Creating Copies of a Table
29.Creating a New Table by Copying
30.Creating a Table
31.Add an IF NOT EXISTS clause to the statement: