我用select @@identity可以返回最后插入的标记
用select SCOPE_IDENTITY()出现以下错误:
Error Code : 1305
FUNCTION db.IDENT_CURRENT does not exist请问MYSQL中是否可以写select SCOPE_IDENTITY()
用select SCOPE_IDENTITY()出现以下错误:
Error Code : 1305
FUNCTION db.IDENT_CURRENT does not exist请问MYSQL中是否可以写select SCOPE_IDENTITY()
似乎没有SCOPE_IDENTITY()吧
begin
set @a = last_insert_id();
end;The variable named @a is what you want.