数据库|mysql教程
MySQL,存储,过程中,使用,WHILE,循环,语句,详细
数据库-mysql教程
免费二级域名分发源码,ubuntu底下删除文件,java 常用爬虫框架,php map key,龙岩seo定制lzw
无详细内容 MySQL mysqlmysql delimiter $$mysqlmysql CREATE PROCEDURE myProc() – BEGIN – – DECLARE i int; – SET i=1; – loop1: WHILE i=10 DO – IF MOD(i,2)0 THEN /*Even number – try again*/ – SELECT CONCAT(i,” is an odd number”); – END IF; – SE
asp在线考试系统毕业设计源码,ubuntu GTX650,网络爬虫研究方向,php sever,seo发文渠道lzw
婚纱摄影社网站dedecms模板源码,Ubuntu显示字体设置,爬虫原理与清洗,php akcms,seo基本知lzw
MySQL
.CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;}.CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;}.CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;}.CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;}.CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;}.CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;}.CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;}.CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;}.CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;}.CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;}
mysql>mysql> delimiter $$mysql>mysql> CREATE PROCEDURE myProc() -> BEGIN -> ->DECLARE i int; ->SET i=1; ->loop1: WHILE iIF MOD(i,2)0 THEN /*Even number - try again*/ -> SELECT CONCAT(i," is an odd number"); ->END IF; ->SET i=i+1; ->END WHILE loop1; -> END$$Query OK, 0 rows affected (0.00 sec)mysql>mysql> delimiter ;mysql> call myProc();