请问以下的语句哪里出错了呢?
set @sqlTxt=concat('if not exists(select * from ',JavaWk_Dbname,'.J_LanMu where LanMuLeiBie=',FaBuLX,' and LanMuMingCheng=',LanMuMingCheng,' and ZaZhiID=',JavaWk_ZaZhiID,
' ) then insert into ',JavaWk_Dbname,'.J_LanMu(ZaZhiID,LanMuLeiBie,LanMuMingCheng,LanMuShunXu)
select ',JavaWk_ZaZhiID,',',FaBuLX,',',LanMuMingCheng,', (select case when max(LanMuShunXu) is null then 1 ; else max(LanMuShunXu)+1 end from',JavaWk_Dbname,';',
'end if;');
prepare s1 from @sqlTxt;
execute s1;
deallocate prepare s1;
set @sqlTxt=concat('if not exists(select * from ',JavaWk_Dbname,'.J_LanMu where LanMuLeiBie=',FaBuLX,' and LanMuMingCheng=',LanMuMingCheng,' and ZaZhiID=',JavaWk_ZaZhiID,
' ) then insert into ',JavaWk_Dbname,'.J_LanMu(ZaZhiID,LanMuLeiBie,LanMuMingCheng,LanMuShunXu)
select ',JavaWk_ZaZhiID,',',FaBuLX,',',LanMuMingCheng,', (select case when max(LanMuShunXu) is null then 1 ; else max(LanMuShunXu)+1 end from',JavaWk_Dbname,';',
'end if;');
prepare s1 from @sqlTxt;
execute s1;
deallocate prepare s1;
The following SQL statements can be used in prepared statements: CREATE TABLE, DELETE, DO, INSERT, REPLACE, SELECT, SET, UPDATE, and most SHOW statements.