Как написать DBMS_OUTPUT.PUT_LINE(sqlcode||SQLERRM); в mysql?
i want convert DBMS_OUTPUT.PUT_LINE(sqlcode||SQLERRM); in mysql. i replaced with PUT_LINE(concat(infull(sqlcode,''),infull(SQLERRM, ''))); but showing errors- unexpected identifier. please help me
Что я уже пробовал:
create procedure Purge_Data is begin declare exit handler for sqlexception begin PUT_LINE(concat(infull(sqlcode,''),infull(SQLERRM, ''))); delete from IP21_TAGDATA where TIMESTAMP <= (trunc(sysdate) - 2); delete from IP21_TAGDATA1 where TIMESTAMP <= (trunc(sysdate) - 2); end;