For API call from the MySQL need to add function, for function need to add install plugin.
Linux server
Setup function for API call from MySQL
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
// git clone https://github.com/mysqludf/lib_mysqludf_sys echo "/var/lib/mysql" > /etc/ld.so.conf.d/mysql.conf echo "/var/lib/mysql/lib/mysql/" > /etc/ld.so.conf.d/mysql.conf ./configure --prefix=/var/lib/mysql --with-mysql=/var/lib/mysql/bin/mysql_config /var/lib/mysql -S /tmp/mysql.sock create function http_get returns string soname 'mysql-udf-http.so.0.0.0'; create function http_post returns string soname 'mysql-udf-http.so.0.0.0'; create function http_put returns string soname 'mysql-udf-http.so.0.0.0'; create function http_delete returns string soname 'mysql-udf-http.so.0.0.0'; SELECT http_get('http://198.1.69.4/api/index.php/user/push_notification') AS data; |
More Stories
How to reset or change the MySQL root password?
Incorrect datetime value: ‘0000-00-00 00:00:00’ for column
MySQL String Functions