GNU Info

(mysql.info)Adding procedures

---

Next: MySQL internals Prev: Adding functions Up: Extending MySQL

---

Enter node , (file) or (file)node

Adding New Procedures to MySQL
==============================

In MySQL, you can define a procedure in C++ that can access and modify
the data in a query before it is sent to the client.  The modification
can be done on row-by-row or `GROUP BY' level.

We have created an example procedure in MySQL Version 3.23 to show you
what can be done.

Additionally we recommend you to take a look at 'mylua', which you can
find in the Contrib directory. Note: Contrib.  Which this you can use
the LUA language to load a procedure at runtime into `mysqld'.

procedure analyse

Procedure analyse

Writing a procedure

Writing a procedure.