MySQL Common SQL statements

A useful common statement.

MySQL Display database or table:

The following are the referenced contents:
Show databases;//can then use database_name;
Show tables;

MySQL Change table name:

ALTER TABLE table_name rename new_t;

MySQL Add columns:

ALTER TABLE table_name ADD column c_n column attributes;

MySQL Delete column:

ALTER TABLE table_name DROP column c_n;

MySQL CREATE index:

ALTER TABLE c_table Add index (C_N1,C_N2);
ALTER TABLE c_table add unique index_name (c_n);
ALTER TABLE c_table add primary key (SID); Webjx.com

MySQL Delete index:

ALTER TABLE c_table DROP INDEX c_n1;

MySQL Change column information:

ALTER TABLE t_table change c_1 c_1 varchar (200);
ALTER TABLE t_table Modify 1 c_1 varchar (200);

Insert Insertion Statement:

INSERT INTO table_name (c_1,c_2)
VALUES (' x1 ', 1);

UPDATE statement:

UPDATE table_name set c_1 =1 where c_2=3;

MySQL Delete database or table:

DROP TABLE table_name;
The drop database database_name;//uses mysql_drop_db () to delete