ms sql server 2000 的sql语句如下:
declare @selstr varchar(1000)
set @selstr='select * from northwind.orders'
execute(@selstr)如何改写成mysql 的语句??
请高手帮一下,急啊.看下这样写对不对:
set @selstr='select * from northwind.orders';
prepare stmt from @selstr;
execute stmt;
declare @selstr varchar(1000)
set @selstr='select * from northwind.orders'
execute(@selstr)如何改写成mysql 的语句??
请高手帮一下,急啊.看下这样写对不对:
set @selstr='select * from northwind.orders';
prepare stmt from @selstr;
execute stmt;
这个语句就已经错了,因为没有指定字段名,在mysql中应该是:
select @str = 'select * from a limit 1';
答案肯定是FALSE你如果只想给@str赋值的话应该这样:select @str := 'select * from a limit 1';
或者:set @str = 'select * from a limit 1';