MySQL Operation basic command

Index  from table_name

CREATE INDEX: CREATE INDEX on table_name (COLUMN_NAME) creates a unique index: creationUnique  index on table_name (COLUMN_NAME) Creating a federated Index:Createindex  on table_name (COLUMN1_NAME,COLUMN2_NAME)

Delete index:drop -Index on TABLE_NAME

Create Table table_name

New table:create table table_name (

              ID int NOT NULL auto_increment,              name varchar (NO) NULL, age              int not NULL,              primary key (ID)

Insert statement: INSERT INTO table_name (COLUMN1_NAME, Column2_name) VALUES (column1_value,column2_value)

Emptying the information in the table:truncatetable table_name

 Full  from table_name

MySQL Operation basic command