--ûظip
select ip from web_session group by ip having count(*)>1;

--鶩Ƿдظ¼
select a.id,b.username,a.no,a.color,a.bx from web_order a,web_client b where a.uid=b.id group by a.uid,a.iid,a.color,a.bx having count(*)>1

--һû
grant all privileges on *.* to hehe@localhost identified by "hehe" WITH GRANT OPTION;

--ȨԶ
grant all privileges on *.* to hehe@'%' identified by "hehe";

--޸ıֶ
alter table web_zk modify zk decimal(5,2) unsigned not null default '0.00';

--
create index ind_upath on web_order (upath);  

--ѯıļ
select * from web_order into outfile 'c:/1.txt';

--ݿ
mysqldump -hlocalhost -uhehe --default-character-set=latin1 -p edt > d:\edt.sql

--ָݿ
mysql -hlocalhost -uhehe -p edt_ybd < D:\web\edt\cli\hz\ibd\mysql_ibd_2018x_20171107185606.sql


--ѯ־
show variables like '%quer%';        slow_query_logֵΪONΪѯ־OFFΪرѯ־
                                     long_query_time ָѯִֵʱ䳬ֵΪѯ䣬ĬֵΪ10롣
set global slow_query_log=on;        ѯ־
show global status like '%slow%';    ʾѯ״̬