MySQL Common SQL statements

MySQL Display database or table:

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;

Drop database database_name;//using mysql_drop_db () can be deleted.