Create table: auto increment primary key

   
Drop table Product;
  
CREATE TABLE Product
(
   ID SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
   Name VARCHAR(40) NOT NULL,
   PRIMARY KEY (ID)
);

Describe Product;

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: ENUM and set
9.	Create table: YEAR and TIMESTAMP
10.	Create table: null and not null
11.	Create table: not null and default value
12.	Create table: default int value
13.	Create table: primary key
14.	Create table: primary key 2
15.	Create table: two columns for 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:

Create table: auto increment primary key : Create Table « Table Index « SQL / MySQL

Related examples in the same category