SQLize Online / PHPize Online  /  SQLtest Online

CREATE OR REPLACE PROCEDURE enr_proc() RETURNS VARCHAR LANGUAGE SQL AS $$ BEGIN INSERT INTO enr ( enrichment_ip, country, company_name, company_id, information_level, data_source ) SELECT DISTINCT enrichment_ip, country, company_name, company_id, information_level, data_source FROM enr_stream WHERE action = 'INSERT' AND ip_ad NOT IN (SELECT ip_ad FROM enr); END; $$ ;