mysql commonly use statement

Create table

mysql> CREATE  table if not exists tblname like old_tblname;

INSERT ... SELECT

mysql> INSERT INTO tblname1 SELECT *  from tblname2 where ...;

Empty table

mysql> TRUNCATE table story_longcon_40;

Delete/Drop table

mysql> DROP TABLE tblname; 

Delete/Drop database

mysql> DROP {DATABASE | SCHEMA} [IF EXISTS] db_name

Optimize Table

mysql> OPTIMIZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name [, tbl_nam