Mysql中存储过程if else的问题简析_MySQL
- WBOYOriginal
- 2016-06-01 13:42:311459browse
bitsCN.com
以下这样写会报错：
[Error] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'end if' at line 8 create procedure test(in a int) if a > 1 then select 1; elseif a>2 then select 2; else end if; [xhtml]create procedure test(in a int) if a > 1 then select 1; elseif a>2 then select 2; else end if; 应改成以下这样： create procedure test(in a int) if a > 1 then select 1; elseif a>2 then select 2; else -- do nothing -- set @tmp=1; end if; 作者 zhu473105308 bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：linux定时备份mysql数据库_MySQLNext article：MySQL的substring_index函数简析_MySQL