MySQL CREATE table

MySQL is used for the first time, simply record some of the common commands used in this project

Start MySQL under 1.win

Open the command line and enter:

Mysql-uroot-p

2. Enter the command show databases;

Select the operational database for the build table use Sina_blog

Build table named Class_list

Change the primary key ID to name
ALTER TABLE class_list Change ID name mediumint (8) auto_increment

CREATE TABLE  int(one notNULLPRIMARYKEYvarchar (255varchar(),countint(  One ))

. Create a federated primary key:

CREATE TABLEarticle_list (IDvarchar( -) not NULL, titlevarchar(255), URLvarchar(255), class_idint( One) not NULL, Created_timeint( One),PRIMARY KEY(id,class_id));

. When modified: ALTER TABLE Tb_name add primary key (Field 1, Field 2, Field 3);

MySQL CREATE table