MySQL basic operation Alter

View database show databases;

The new Database command creates the library name.

Select database Use 2016test;

CREATE TABLE: Create table table name (Field ....);

Auto_increment Self-increment

Primary KEY Primary Key

View table structure: Describe table name

Show Table:

Inserting data

Tabular

Delete Field Name:

ALTER TABLE name drop field name;

Add Table field

ALTER TABLE name add field name type;

To modify a table field:

ALTER TABLE indicates the new field name of the Change field name new field type;

modifying field types

ALTER TABLE name modify the field name you want to modify the new field type;

To view the table engine:

Show CREATE TABLE 2016_test;

。。。。

。。。。

To modify the table engine:

ALTER TABLE 2016_test Engine=myisam;

MySQL basic operation Alter