2016/04/28 (Preliminary knowledge of the database)

mysql-uroot-p;//Opening a database
Admin Enter password
Show databases;//queries all of the libraries
Use student;//into the corresponding library or table
Create database database name;//Creating a library
drop database name;//Delete a library
Create database if not exists library name;//creates a new inject without creating an error prevention
Cerate database if not EXISTS library name default CharSet utf8;//create a new library and set its encoding format
The CREATE table if not EXISTS table name (attributes of the table);//Creating a table
Insert into table name values ();//Add Table Properties
SELECT * from table name;//query All information in table
Show columns from table name;//print all rows and columns in the table
DESC table name;//All row and column methods in the same printed table are simple
Insert into table name (attributes to be added) values ();//Add the specified attribute to the table
ALTER TABLE name add property name;//Add the appropriate attribute to the table
ALTER TABLE name change property name modified attribute;//property changed
ALTER TABLE name drop property;//delete one row in a table
Crate Table select * from old table;//Copy a new table The original table still exists
Ceate Table select * from old table where 1=0;//just copy a table structure inside the data is not copied
SELECT * from table name where property = property variable;//Find specified property
CREATE index Myindex on table name (attribute name);//Gazzo citation
ALTER TABLE table Name DROP INDEX myindex;//Delete an index

2016/04/28 (Preliminary knowledge of the database)