我的常用mysql命令

select count(*) from 5000shot;

select sum(samplenum) from 5000shot;

show variables like "%pro%"; 

set profiling=1;

show profiles;

mysqldump -u root -p 5000shot  < 5000shot.sql

create database test character set utf8;

drop table 01copy;

 create table 5000shotcopy(id BIGINT  unsigned not null AUTO_INCREMENT  PRIMARY KEY,idx_shot int unsigned not null ,idx_tree char(10) not null, idx_subtree char(5) not null, idx_signame char(10) not null,  samplenum int not null);

select idx_shot,idx_subtree,idx_signame  from  0117table where idx_shot='50005';

INSERT INTO 01copy(idx_shot,idx_tree, idx_subtree,idx_signame,samplenum) SELECT idx_shot,idx_tree, idx_subtree,idx_signame,samplenum  FROM 01table

truncate table 01copy

delete from 07table  where idx_tree='east'