现在有这样一个Sybase视图,我想转到Mysql,
create view SQLDB_V_SYSPROCESSES as
select sp.spid,
sp.kpid,
sp.enginenum,
sp.status,
sp.suid,
sp.loggedindatetime,
sp.ipaddr,
loginame = IsNull(get_appcontext('Invest', 'userid'), suser_name())
from master..sysprocesses sp已知get_appcontext(),master..sysprocesses在Mysql是不可用的。求大神指教!!!
create view SQLDB_V_SYSPROCESSES as
select sp.spid,
sp.kpid,
sp.enginenum,
sp.status,
sp.suid,
sp.loggedindatetime,
sp.ipaddr,
loginame = IsNull(get_appcontext('Invest', 'userid'), suser_name())
from master..sysprocesses sp已知get_appcontext(),master..sysprocesses在Mysql是不可用的。求大神指教!!!
谢谢,主要是get_appcontext(),这个方法不知道在mysql有没有对应的。
谢谢,那Mysql有对应的内置函数嘛?