{"id":1403,"date":"2024-05-08T10:15:58","date_gmt":"2024-05-08T02:15:58","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1403"},"modified":"2024-05-08T10:17:35","modified_gmt":"2024-05-08T02:17:35","slug":"mysql%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b%e9%80%a0%e6%95%b0","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1403","title":{"rendered":"mysql\u5b58\u50a8\u8fc7\u7a0b\u9020\u6570"},"content":{"rendered":"

DROP PROCEDURE IF EXISTS insertwristband_info<\/code>;
\nDELIMITER \/\/
\nCREATE PROCEDURE insertwristband_info (IN scount int)
\nbegin
\ndeclare Time1 int DEFAULT 0;
\ndeclare id1 int DEFAULT 99100000;
\nwhile Time1<scount do
\nset Time1=Time1+1;
\nset id1=id1+1;
\nINSERT INTO wristband_info select id1, NULL, UNIX_TIMESTAMP(NOW()), 10084, CONCAT('p', id1), 10091, 1000.00, '', CONCAT('13897',floor(rand()*600000+100000)), NULL, '11', NULL ;
\nif (Time1 mod 10000)=0 then
\ncommit;
\nend if;
\nend while;
\nend;
\n\/\/
\nDELIMITER ;<\/p>\n

call insertwristband_info(1000000); --\u9020100\u4e07<\/h2>\n

DROP PROCEDURE IF EXISTS insertexpenses_record<\/code>;
\nDELIMITER \/\/
\nCREATE PROCEDURE insertexpenses_record (IN scount int)
\nbegin
\ndeclare Time2 int DEFAULT 0;
\ndeclare id2 int DEFAULT 90000000;
\nwhile Time2<scount do
\nset Time2=Time2+1;
\nset id2=id2+1;
\nINSERT INTO expenses_record select id2, NULL, NULL, NULL, '\u5145\u503c', 1000.00, NULL, NULL, 1.00, 1000.00, 0.00, 100, 10121, 10006, NULL, null, '2222222222', NULL, 10013, NULL, 10021, NULL, date_format(now(), '%Y-%m-%d %T'), date_format(now(), '%Y-%m-%d %T'), '01', date_format(now(), '%Y-%m-%d %T'), date_format(now(), '%Y-%m-%d %T'), 'system', '\u8d85\u7ea7\u7ba1\u7406\u5458', '2222222222_\u5145\u503c', '11', '316', '01', concat(date_format(now(), '%Y%m%d%H%i%s'),FLOOR(rand()900+100)), NULL, 'system', '\u8d85\u7ea7\u7ba1\u7406\u5458', CONCAT('13897',floor(rand()<\/em>600000+100000)), 'ptest', NULL;
\nif (Time2 mod 10000)=0 then
\ncommit;
\nend if;
\nend while;
\nend;
\n\/\/
\nDELIMITER ;<\/p>\n

call insertexpenses_record(1000000);<\/h2>\n

DROP PROCEDURE IF EXISTS insertbilling_records<\/code>;
\nDELIMITER \/\/
\nCREATE PROCEDURE insertbilling_records (IN scount int)
\nbegin
\ndeclare Time3 int DEFAULT 0;
\ndeclare id3 int DEFAULT 90000000;
\nwhile Time3<scount do
\nset Time3=Time3+1;
\nset id3=id3+1;
\nINSERT INTO billing_records select id3, null, NULL, NULL, 0.00, 100, 1000.00, 10000.00, '\u4f1a\u5458\u5361', date_format(now(), '%Y-%m-%d %T'), 0;
\nif (Time3 mod 10000)=0 then
\ncommit;
\nend if;
\nend while;
\nend;
\n\/\/
\nDELIMITER ;<\/p>\n

call insertbilling_records(1000000);<\/p>\n

\n

DROP PROCEDURE IF EXISTS insertpay_record<\/code>;
\nDELIMITER \/\/
\nCREATE PROCEDURE insertpay_record (IN scount int)
\nbegin
\ndeclare Time4 int DEFAULT 0;
\ndeclare id4 int DEFAULT 80000000;
\nwhile Time4<scount do
\nset Time4=Time4+1;
\nset id4=id4+1;
\nINSERT INTO pay_record select id4, id4, 10101, '0', 1000.00, NULL, date_format(now(), '%Y-%m-%d %T'), '01', 11;
\nif (Time4 mod 10000)=0 then
\ncommit;
\nend if;
\nend while;
\nend;
\n\/\/
\nDELIMITER ;<\/p>\n

call insertpay_record(1000000);<\/h2>\n","protected":false},"excerpt":{"rendered":"

DROP PROCEDURE IF EXISTS insertwristband_info; DELIMITER \/\/ CREATE PROCEDURE insertwristband_info (IN scount int) begin declare Time1 int DEFAULT 0; declare id1 int DEFAULT 99100000; while Time1<scount do set Time1=Time1+1; set id1=id1+1; INSERT INTO wristband_info select id1, NULL, UNIX_TIMESTAMP(NOW()), 10084, CONCAT(‘p’, id1), 10091, 1000.00, ”, CONCAT(‘13897′,floor(rand()*600000+100000)), NULL, ’11’, NULL ; if (Time1 mod 10000)=0 then commit; end if; end while; end; \/\/ DELIMITER ; call insertwristband_info(1000000); –\u9020100\u4e07 DROP PROCEDURE IF EXISTS insertexpenses_record; DELIMITER \/\/ CREATE PROCEDURE insertexpenses_record (IN scount int) begin declare Time2 int DEFAULT 0; declare id2 int DEFAULT 90000000; while Time2<scount do set Time2=Time2+1; set id2=id2+1; INSERT INTO expenses_record select id2, NULL, NULL, NULL, ‘\u5145\u503c’, 1000.00, NULL, NULL, 1.00, 1000.00, 0.00, 100, 10121, 10006, NULL, null, ‘2222222222’, NULL, 10013, NULL, 10021, NULL, date_format(now(), ‘%Y-%m-%d %T’), date_format(now(), ‘%Y-%m-%d %T’), ’01’, date_format(now(), ‘%Y-%m-%d %T’), date_format(now(), ‘%Y-%m-%d %T’), ‘system’, ‘\u8d85\u7ea7\u7ba1\u7406\u5458’, ‘2222222222_\u5145\u503c’, ’11’, ‘316’, ’01’, concat(date_format(now(), ‘%Y%m%d%H%i%s’),FLOOR(rand()900+100)), NULL, ‘system’, ‘\u8d85\u7ea7\u7ba1\u7406\u5458’, CONCAT(‘13897’,floor(rand()600000+100000)), ‘ptest’, NULL; if (Time2 mod 10000)=0 then commit; end if; end while; end; \/\/ DELIMITER ; call insertexpenses_record(1000000); DROP PROCEDURE IF EXISTS insertbilling_records; DELIMITER \/\/ CREATE PROCEDURE insertbilling_records (IN scount int) begin declare Time3 int DEFAULT 0; declare id3 int DEFAULT 90000000; while Time3<scount do set Time3=Time3+1; set id3=id3+1; INSERT INTO billing_records select id3, null, NULL, NULL, 0.00, 100, 1000.00, 10000.00, ‘\u4f1a\u5458\u5361’, date_format(now(), ‘%Y-%m-%d %T’), 0; if (Time3 mod 10000)=0 then commit; end if; end while; end; \/\/ DELIMITER ; call insertbilling_records(1000000); DROP PROCEDURE IF EXISTS insertpay_record; DELIMITER \/\/ CREATE PROCEDURE insertpay_r…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[83],"tags":[],"class_list":["post-1403","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1403"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1403\/revisions"}],"predecessor-version":[{"id":1404,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1403\/revisions\/1404"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}