如何将sqlserver的sql语句转成mysql

sqlserver的sql语句是：

declare @str nvarchar(500)
set @str='select * from '+(select top 1 CategaryName from sort)+'.dbo.type2'
exec (@str)

用mysql怎么写？？？

差不多呢。

SET @COUNT_STRING = CONCAt('SELECt * FROM ', 't_admin', ' where 1=1 ', ' and id=7');
PREPARE count_stmt FROM @COUNT_STRING;
EXECUTE count_stmt;

create procedure getnextseq2 tablename varchar(255),out nextseq numeric(10),out lastseq numeric(10) begin update carefx_table_seq set lastseq = seq = seq + 10 where table_name=tablename; set nextseq = lastseq-10; set lastseq = lastseq-1; end;

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息