MySQL常用SQL语句

 1.给起始时间 增加 随机的秒数。即随机指定范围时间

UPDATE article SET update_time = DATE_ADD('2020-04-01 00:00:00',INTERVAL FLOOR(1+(RAND()*3924000)) SECOND);

2.创建用户并授权

CREATE USER 'daily'@'172.17.0.6' IDENTIFIED BY 'L5wkRPK0MNYcsiLcUG';
grant all privileges on jpress.* TO 'daily'@'172.17.0.6';

3.导出数据

mysqldump -uroot -p123456 test_table > /data/test_table.sql