MySQL?洢??????????????
?????BuleSky ???????[ 2016/11/17 11:20:09 ] ????????MySQL ?????
???????7??REPEAT?????
????mysql> delimiter //
????mysql> CREATE PROCEDURE dorepeat(p1 INT)
????-> BEGIN
????-> SET @x = 0;
????-> REPEAT
????-> SET @x = @x + 1;
????-> UNTIL @x > p1 END REPEAT;
????-> END
????-> //
????Query OK?? 0 rows affected (0.00 sec)
????mysql> CALL dorepeat(1000)//
????Query OK?? 0 rows affected (0.00 sec)
????mysql> SELECT @x//
????+------+
????| @x |
????+------+
????| 1001 |
????+------+
????1 row in set (0.00 sec)
????WHILE???
????[begin_label:] WHILE search_condition DO
????statement_list
????END WHILE [end_label]
???????????????????REPEAT???????????WHILE????????????????????REPEAT??????????????????WHILE???????????????????????????????0?Σ???REPEAT??????????????????ж???????????????????1?Ρ?
???????8??WHILE?????
????REATE PROCEDURE dowhile()
????BEGIN
????DECLARE v1 INT DEFAULT 5;
????WHILEv1 > 0 DO
????...
????SETv1 = v1 - 1;
????ENDWHILE;
????END;
?????????????
???????????????MySQL5.1?????????????????????????????????????????????????????????????????Linux???μ???????crontab
?????磺
????CREATE EVENT myevent
????ONSCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR
????DO
????UPDATE myschema.mytable SET mycol = mycol + 1;
???????У?
????<1>?????????CREATE EVENT?????????????
????<2>???ON SCHEDULE???????????????м??????Σ?
????<3>???DO?????????е??????????????
?????????????д??????????????????е????????????????1С??????????????±??????
?????????????????????????????
????SET GLOBAL event_scheduler = 1??
????????????????????????????????disable?????????drop????
????ALTER EVENT myevent disable;
????DROP EVENT myevent;
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
?????????????????????????Щ????????????????????TC???????????????Щ???????????????????????????????????????????????(java .net ?????)???mysql???????????????????ж????д???Python???????????????(DB2)??????BufferPool????????????????????????????????6??????????????????滮???????????????-????????SQL Server???????????????????λ?????PHP??SQL????????????????????Pythonд???NoSQL????????? SQL ?е????????????? SQL ?е?????????Java???????:?????MySQL???????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????