SQL Server代码到mysql代码的转换

本文介绍了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)