wwwwcc..ddok..occkcuacrau-tr-tmysql_Mysql_100W20 mysql ::mysql>delimiter $mysql>SET AUTOCOMMIT = 0$$mysql> create procedure test()begindeclare i decimal (10) default 0 ;dd:loopINSERT INTO `million` (`categ_id`, `categ_fid`, `SortPath`, `address`, `p_identifier`, `pro_specification`,`name`, `add_date`, `picture_url`, `thumb_url`, `is_display_front`, `create_html_time`, `hit`, `buy_sum`,`athor`, `templete _style`, `is_hot`, `is_new`, `is_best`) VALUES(268, 2, '0,262,268,', 0, '2342', '423423', '123123', '2012-01-09 09:55:43', 'upload/product/20111205153432_53211.jpg', 'upload/product/thumb_20111205153432_53211.jpg', 1, 0, 0, 0, 'admin', '0', 0, 0,0);commit;set i = i+1;if i= 1000000 then leave dd;end if;end loop dd ;end;$mysql>delimiter ;mysql> call test;mysql> call test; Query OK, 0 rows affected (58 min 30.83 sec)PHP:mysql_Mysql_ChhaXCan--XnFDFPPDhttp://www.jb51.net/article/30099.htmggeeClick to buy NOW!wwcc..dd..SELECT chid,catid,softid... FROM `downitems` WHERE itemid >= (SELECT floor(RAND() * (SELECT MAX(itemid) FROMwwomooccuu--ttrraacckk`downitems`))) ORDER BY itemid LIMIT 1000;10005000100:http://www.jb51.net/article/30099.htm
2012/8/13 20:53
因篇幅问题不能全部显示,请点此查看更多更全内容
Copyright © 2019- haog.cn 版权所有 赣ICP备2024042798号-2
违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务