Define and use primary key

  
/*
mysql> Drop table Attributes;

mysql> CREATE TABLE Attributes
    -> (
    ->    ID SMALLINT NOT NULL PRIMARY KEY,
    ->    Settings TINYINT UNSIGNED NOT NULL
    -> );
Query OK, 0 rows affected (0.06 sec)

mysql> INSERT INTO Attributes VALUES (101, 58),
    ->                               (102, 73),
    ->                               (103, 45);
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select * from Attributes;
+-----+----------+
| ID  | Settings |
+-----+----------+
| 101 |       58 |
| 102 |       73 |
| 103 |       45 |
+-----+----------+
3 rows in set (0.00 sec)

*/

Drop table Attributes;

CREATE TABLE Attributes
(
   ID SMALLINT NOT NULL PRIMARY KEY,
   Settings TINYINT UNSIGNED NOT NULL
);


INSERT INTO Attributes VALUES (101, 58), 
                              (102, 73), 
                              (103, 45);
select * from Attributes;

Related examples in the same category

1.	Setting a Primary Key 1
2.	Setting a Primary Key 2
3.	Setting a Primary Key 3
4.	Alter table to Add an PRIMARY KEY
5.	Another way to enforce uniqueness is to add a UNIQUE index rather than a PRIMARY KEY to a table.
6.	To drop an index that is not a PRIMARY KEY, you must specify the index name.
7.	Adding primary key for not null column
8.	Defining Primary Keys
9.	Use a PRIMARY KEY constraint
10.	If you were creating a primary key on more than one column, you would include both of those column names in th
11.	Two ways to declare primary key when creating the table
12.	Create a table t that contains an id column that's NOT NULL and declared as a primary key by means of a PRIMAR
13.	A primary key on a column can be created by replacing PRIMARY KEY with UNIQUE in the table definition, provide
14.	Add PRIMARY KEY or UNIQUE directly to the end of the column definition.
15.	Create a primary key on the last_name and first_name columns using a PRIMARY KEY clause
16.	Create a multiple-column primary key using UNIQUE, if the columns are declared NOT NULL
17.	Using three column as the primary key
18.	Drop primary key

Define and use primary key : Primary Key « Key « SQL / MySQL

Related examples in the same category