MySQL CREATE table

1. Delete tables drop table table_name; TABLE_NAME Table name

2. Create a table that has the primary key index created when a property is marked as a primary key

Create Table  Student_info (
ID int NOT NULL  auto_increment primary key comment ' primary key ID ',

Name varchar () null comment ' name ',
　　
    Unique ID (ID ASC)                 //Create PRIMARY key single index
　　

);

Index of the Classification display table for MySQL index

Index  from table;

Normal

How to create

index(column   desc| ASC)  #index index alias column field name

Features: General index

Unique |full text

How to create

Unique Index (columndesc| ASC)

Features: Unique requires only full text time consuming space

3. Timestamp format

Create Table  intnotnullprimarykey,        createtime timetamp  # The timestamp format defaults to  the time of 0000-00-00 00:00:00 format);

4. Integral type

tinyint of one byte

SmallInt 2 bytes

int 4 bytes

BigInt 8 bytes

5. Char and varchar mysql5 are followed by the maximum length of the character varchar 65,000

MySQL CREATE table