MYsql如何像SqlServer一样在查询分析器中执行多行语句
- SQL code
use pubsdeclare @fid int declare @milestone intdeclare @count intdeclare @val intset @fid = 1set @milestone = 1truncate table milestone--得到总的milestone数select @count = count(1) / 10000from threadwhere fid = @fid--第一个milestoneselect top 1 @val = lastpostfrom thread with ( nolock )where fid = @fid and lastpost not in ( select top 10000 lastpost from thread with ( nolock ) where fid = @fid order by lastpost desc )order by lastpost descinsert into milestone ( fid, milestone, lastpostdesc )values ( @fid, @milestone, @val )set @milestone = @milestone + 1while ( @milestone <= @count ) begin select top 1 @val = lastpost from thread with ( nolock ) where fid = @fid and lastpost < @val and lastpost not in ( select top 10000 lastpost from thread with ( nolock ) where fid = @fid and lastpost < @val order by lastpost desc ) order by lastpost desc insert into milestone ( fid, milestone, lastpostdesc ) values ( @fid, @milestone, @val ) set @milestone = @milestone + 1 end
在SqlServer中我们常常合并多行语句然后直接执行,但是在mysql中如何执行以上语句呢?
我是想直接在代码里边执行,例如:
mySqlHelper.ExecuteQuery("这里是上面的sql语句");
[解决办法]
MYSQL中无法实现这种过程式语句,只能在存储过程中使用。
如果是一般的多条SQL语句则可以通过分号来分隔即
select now(); select 1+1 ;
[解决办法]
mysql是不能执行多条语句的。每条语句要分号隔开的。
mysql要实现此功能必须在存储过程中实现的。