gistfile1.txt

Executing: mysql -udbwebb < example/sql/list_proc_func_trig.sql
SHOW TABLES;
+-----------------+
| Tables_in_eshop |
+-----------------+
| accountLog      |
| kategori        |
| kundregister    |
| order_rows      |
| orders          |
| orders_and_rows |
| picklista       |
| product_log     |
| produktkategori |
| produktregister |
| shelf           |
| v_lager         |
| v_log           |
| v_proc          |
| v_trig          |
| v_typ           |
+-----------------+
SELECT * FROM v_proc;
+--------------------+-----------+-------+
| Name               | Type      | Db    |
+--------------------+-----------+-------+
| order_status       | FUNCTION  | eshop |
| add_order_row      | PROCEDURE | eshop |
| change_status      | PROCEDURE | eshop |
| create_product     | PROCEDURE | eshop |
| delete_product     | PROCEDURE | eshop |
| edit_product       | PROCEDURE | eshop |
| enter_shelf        | PROCEDURE | eshop |
| get_order_picklist | PROCEDURE | eshop |
| get_order_rows     | PROCEDURE | eshop |
| insert_kund        | PROCEDURE | eshop |
| name_log           | PROCEDURE | eshop |
| order_and_rows     | PROCEDURE | eshop |
| order_kund         | PROCEDURE | eshop |
| order_kund_id      | PROCEDURE | eshop |
| remove_antal       | PROCEDURE | eshop |
| remove_lager       | PROCEDURE | eshop |
| search             | PROCEDURE | eshop |
| search_order       | PROCEDURE | eshop |
| show_kunder        | PROCEDURE | eshop |
| show_shelf         | PROCEDURE | eshop |
| tabort_product     | PROCEDURE | eshop |
+--------------------+-----------+-------+
SELECT * FROM v_trig;
+-------+-----------------+--------+--------+----------------+
| Db    | Table           | When   | Event  | Name           |
+-------+-----------------+--------+--------+----------------+
| eshop | produktregister | AFTER  | DELETE | delete_product |
| eshop | produktregister | BEFORE | INSERT | insert_product |
| eshop | produktregister | AFTER  | UPDATE | update_product |
+-------+-----------------+--------+--------+----------------+