MySQL stored procedures

A case of MySQL stored procedure

DROP PROCEDURE IF EXISTS saveorupdate_sub_key_proc; CREATE PROCEDURE Saveorupdate_sub_key_proc (in Sub_id_argint(4), in English_arg varchar ( -), in Hindi_arg varchar ( -), in Marathi_arg varchar ( -), in Tamil_arg varchar ( -)) Begindeclare Count_sub_item INT (4); SelectCOUNT (*) into Count_sub_item fromSubject_keywordswheresub_id =Sub_id_arg; ifCount_sub_item >0Then update Subject_keywordsSet中文版 = English_arg,hindi = Hindi_arg,marathi = Marathi_arg,tamil = Tamil_argwheresub_id =Sub_id_arg; ELSE INSERT INTO Subject_keywords (sub_id,english,hindi,marathi,tamil) VALUES (Sub_id_arg,english_arg,hindi_arg,    MARATHI_ARG,TAMIL_ARG); Endif; SelectCount_sub_item; End;call Saveorupdate_sub_key_proc (412,' A','AA','cc','DD');

MySQL stored procedures