MySQL Scheduled Tasks

Database Links:

Mysql-uroot-p <!--database connection--
Mysql-h10.0.0.100-ustaging-pn3ktxg
Show Databases <!--See all db-->
INSERT into ' user ' (
Select id+3333504, ' user_name ', ' password ',
' Birthday ', ' mobile ', ' email ', ' province ', ' City ', ' region ', ' create_at ', ' update_at ',
' Login_at ', ' last_login_at ', ' account_status ', ' account_open_at ', ' risk_at ', ' risk_end ', ' risk ',
' Nick ', ' sms_status ', ' source ', ' fund_account ', ' branch_no ', ' id_no ', ' client_name ',
' friend_id ', ' client_id ', ' user_type ', ' sale_licence ', ' operate_code ', ' user_status ', ' user_trace ', ' remote_addr ', ' Channel '
From ' user ') <!----Insert test data--

To schedule a task:

Mysql> Show variables like "%pro%";<!---Check if profile is open (not open)--
Mysql> set profiling=1; <!--set Profile open-
mysql> use test--switch using DB
Select Id_no,user_name,mobile from ' User ' where SUBSTR (id_no,11,4) = ' 0512 '; --Execute SQL
Mysql> Show Profiles; --View SQL Records
Mysql> Show profile for query 2; ---View details Scheduled Tasks
Mysql> Show profile block io,cpu for Query 3; ---CPU, io usage
Mysql> Show profile memory for query 3; --Memory usage

Time stamp:

Mysql>select from_unixtime (1249488000, '%y%m%d ')
mysql> SELECT unix_timestamp (' 2009-08-06 ');
SELECT date_format (date_id, '%y-%m-%d ') from Batch_select_check_point a where date_id< str_to_date (' 2016-08-10 ', '% y-%m-%d ')

*********************

Often use Oracle, with MySQL, to record

MySQL Scheduled Tasks