MySQL creates a database and table Demo, and mysql creates a demo.

MySQL creates a database and table Demo, and mysql creates a demo.

Demo:

Database creation syntax
1. Basic syntax
Create database tour character set gbk;

Use tour;
Auto-increment with no primary key
Create table EMB_T_Employee
(
Emb_c_operatorID int not null,
Emb_c_empCode varchar (255) not null,
Emb_c_gender int not null,
Emb_c_email varchar (255) not null,
Emb_c_empMPhone varchar (255) not null,
Emb_c_empTel varchar (255 ),
Emb_c_empZipCode varchar (50 ),
Emb_c_empPID varchar (50 ),
Emb_c_empBirthDate datetime,
Emb_c_empAddress varchar (512 ),
Emb_c_regDate datetime not null,
Emb_c_displayOrder int not null,
Primary key (emb_c_operatorID)
) Engine = INNODB default charset = gbk;
The starting point of an uncontrolled primary key with a primary key auto-Increment
Create table emb_t_dictBusType
(
Emb_c_busTypeID int not null auto_increment,
Emb_c_busTypeEnName varchar (255) not null,
Emb_c_busTypeZhName varchar (255) not null,
Primary key (emb_c_busTypeID)
) Engine = INNODB default charset = gbk;
Start point of a primary key with auto-increment primary key control
Create table emb_t_dictBusType
(
Emb_c_busTypeID int not null auto_increment,
Emb_c_busTypeEnName varchar (255) not null,
Emb_c_busTypeZhName varchar (255) not null,
Primary key (emb_c_busTypeID)
) Engine = INNODB auto_increment = 1001 default charset = gbk;
2. view all current data
Show databases;
3. view all tables in the current database
Show tables;
4. view the table structure
Desc emb_t_dictBusType;
5. View character sets
Show variables like 'collation _ % ';
Show variables like 'character _ set _ % ';
6. Modify the character set of the database
Alter database tour character set UTF-8;

 

Copyright: http://www.blogjava.net/sxyx2008/