来自太阳的我

创建存储过程create or replace PROCEDURE addupoperate ASBEGIN insert into imp_operatequantity(pck,screen,click,download,setup,gysdkv,time,appid) select pck,screen,click,download,setup,gysdkv,time,appid

#存储过程，更改7天外用户状态#DELIMITER $$CREATE PROCEDURE temp()BEGINUPDATE zy_developer SET regstatus=1 WHERE TIMESTAMPDIFF(DAY,STR_TO_DATE(TIME,'%Y-%m-%D'),CURDATE()) >=7;COMMIT;END $$DELIMITER;#

结构：mysqldump –h127.0.0.1 –uroot –pxxxxxxx –P3306 –opt –d 数据库名 表名1 表名2 |gzip –9 >目录/$(date -d "today" +"%Y%m%d_%H%M%S")_daydata.sql.gz1. 参数详解：a) –h --hostb) –u --userc) –p --passwordd) –P --po