mysql> SELECT lookup('localhost');
+---------------------+
| lookup('localhost') |
+---------------------+
| 127.0.0.1 |
+---------------------+
1 row in set (0.00 sec)
mysql> SELECT reverse_lookup('127.0.0.1');
+-----------------------------+
| reverse_lookup('127.0.0.1') |
+-----------------------------+
| localhost |
+-----------------------------+
1 row in set (0.00 sec)
This is how you install these functions.
- Build udf_example.so which is in your mysql source. (make udf_example.so)
- Copy the udf_example.so file from your build directory to your plugin_dir.
- Create the lookup and reverse_lookup functions
mysql> CREATE FUNCTION lookup RETURNS STRING SONAME 'udf_example.so';
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE FUNCTION reverse_lookup RETURNS STRING SONAME 'udf_example.so';
Query OK, 0 rows affected (0.00 sec)
I've created a feature request for IPv6 support to these functions.
yups ...it's really nice and getting lot's of good knowledge....
ReplyDeleteGreat Article Cyber Security Projects projects for cse Networking Security Projects JavaScript Training in Chennai JavaScript Training in Chennai The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
DeleteBefore beginning the design of a database, define the functions the data will be expected to perform. These should be the actual activities you plan to automate through the database, such as mailing lists and traveler preferences, etc.oracle dashboards
ReplyDeleteYour initial step ought to be to discover the best rate of payday advance on offer. Whichever payday advance organization you may pick you should realize what will be the settled sum that you will owe after finishing your payday advance. Payday Loans
ReplyDelete