Three commonly used MySQL build table statements

MySQL Build table statement is one of the most basic SQL statements, the following is to introduce you the most commonly used three MySQL table statements, if you are interested in the MySQL build table statement, you may wish to see.

1, the simplest:

CREATE TABLE T1 (
ID int NOT NULL,
Name Char (20)
);
2, with the primary key:

A:
CREATE TABLE T1 (
ID int NOT NULL PRIMARY key,
Name Char (20)
);
B: Composite PRIMARY key
CREATE TABLE T1 (
ID int NOT NULL,
Name Char (20),
Primary KEY (Id,name)
);
3, with the default value:

CREATE TABLE T1 (
ID int NOT NULL default 0 primary key,
Name char (default ' 1 ')
);

Three common MySQL Build table statements (RPM)