MySQLノート

#      
ALTER TABLE  `members` ORDER BY  `uid`;

#          
SELECT * FROM `members` PROCEDURE ANALYSE();

#            
SELECT * FROM `User` where register_time BETWEEN '2015-03-05' AND '2015-03-06'

#  uid      
SELECT count(DISTINCT uid) as num FROM User

--   data_content_310              t3

Insert into t3 (domain) select distinct    from data_content_310;
Insert into t3 (domain) select distinct    from data_content_311;
Insert into t3 (domain) select distinct    from data_content_312;
Insert into t3 (domain) select distinct    from data_content_313;
Insert into t3 (domain) select distinct    from data_content_314;
Insert into t3 (domain) select distinct wangzhi from fwol;


-- Insert into t4 (domain) select distinct domain from t3;