本文介绍了SQL Server代码到mysql代码的转换的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
declare @cnt int set @cnt=(select MAX(SUBSTRING(Account_Admin.Account_Id,2,LEN(Account_Admin.Account_Id)))+1 from Account_Admin) DECLARE @Account_Id VARCHAR(20) SET @Account_Id = 'A'+CAST(@cnt as varchar)
将其转换为MYSQL的代码是什么?
what is the code to convert it into MYSQL
推荐答案declare @cnt int select @cnt =MAX(SUBSTRING(Account_Admin.Account_Id,2,LEN(Account_Admin.Account_Id)))+1 from Account_Admin DECLARE @Account_Id VARCHAR(20) SET @Account_Id = 'A'+CAST(@cnt as varchar)
更多推荐
SQL Server代码到mysql代码的转换
发布评论