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