To create a new database, you need to pay attention to the place __ database

Create a new database, build a table where you need attention

Build a table and build a database note:

1, Character set: Select GBK, or Utf-8
2, the database name is case-sensitive
3, the table name is strictly case-sensitive, generally with ' t_ ' beginning, words can be tried ' _ ' separated
4, the field name is not case-sensitive, the word can be tried between ' _ ' separated
5, the primary key uses the self-increasing mode
6, Database engine use: InnoDB (Support transaction)
7, PRIMARY KEY constraint, non-empty constraint, index, field name, field type, field initialization, field description;
(Note: The association between tables is implemented in code, do not CREATE TABLE foreign KEY constraints)
8, field settings commonly used type (field names do not match the keyword):
tinyint (4);
int (11);
varchar (20);
DateTime
Text
Decimal (M,n)