trigger mysql to sql server with sys_exec

Question

i use this script in mysql triger after insert on tbl_produk

FOR EACH ROW BEGIN
DECLARE cmd CHAR(255);
DECLARE result INT(100);
SET cmd=CONCAT('/usr/bin/php ', 'http://localhost/triger/add_post.php?produk=', NEW.produk, '&jumlah=', NEW.jumlah);
SET result = sys_exec(cmd);
END;

reference from https://dba.stackexchange.com/questions/39598/update-sql-server-from-mysql

but not runing, i hope an solution for this

Mukesh Kalgude · Accepted Answer · 2015-08-06 03:56:09Z

1

If columns should be numeric than to convert varchar.

SET cmd=CONCAT('/usr/bin/php ', 'http://localhost/triger/add_post.php?produk=',convert(varchar(50),NEW.produk), '&jumlah=', convert(varchar(50),NEW.jumlah));

answered Aug 6, 2015 at 3:56

Mukesh Kalgude

4,8542 gold badges20 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Riky Cloud Over a year ago

thanks this work for insert into tbl_produk, but not update to tbl_trigger_produk,

Mukesh Kalgude Over a year ago

@RikyCloud Not say thanks but given right marks and vot

Riky Cloud Over a year ago

i get error in sqlyog when add code "convert" like this Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR(50),NEW.produk), '&jumlah=', CONVERT(VARCHAR(50),NEW.jumlah)); SET resu' at line 8

Riky Cloud Over a year ago

i think this problem is sys_exec function not exist, how to add lib_mysqludf_sys in mysql? 3hour i search this problem but not runing :D, can you help plis

Collectives™ on Stack Overflow

trigger mysql to sql server with sys_exec

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related