额洗的第一个存储过程

数据库 Mysql

 

DROP PROCEDURE proc_insert_base_ip_geo; CREATE PROCEDURE proc_insert_base_ip_geo ( IN ns_start VARCHAR(15), IN ns_end VARCHAR(15), IN geo_desc VARCHAR(255) ) BEGIN SET @I_NS_START = TRIM(ns_start), @I_NS_END = TRIM(ns_end), @I_GEO_DESC = TRIM(geo_desc), @I_REC_LOGS = '纯真网络 2010年03月10日IP数据', @I_IS_DEL = 0; INSERT INTO base_ip_geo (NS_START, NS_END, GEO_DESC, ADD_DATE, REC_LOGS, IS_DEL) VALUES (@I_NS_START, @I_NS_END, @I_GEO_DESC, SYSDATE(), @I_REC_LOGS, @I_IS_DEL); END;