mySql存储过程

CREATE TABLE pagetest (  id int(11) NOT NULL AUTO_INCREMENT,  col01 int(11) DEFAULT NULL,  col02 varchar(50) DEFAULT NULL,  col03 datetime DEFAULT NULL,  PRIMARY KEY (`id`))

DROP PROCEDURE test_while

DELIMITER $$CREATE PROCEDURE test_while()BEGINDECLARE t INT DEFAULT 0;WHILE t<10000 DOINSERT INTO pagetest(col01,col02,col03) VALUES( FLOOR(1 + (RAND() * 10000)),ConCAT("a",t),NOW());SET t=t+1;END WHILE;END $$DELIMITER ;

CALL test_while();

SELECT id,col01,col02,col03 FROM pagetest ORDER BY col01, col02 LIMIT 10,20

cnblogs/zcttxs/archive/2012/04/01/2429151.html

cnblogs/-beyond/p/6227347.html