Re: RES: System Tables

[Sanja Byelkin]

Hi, Fabricio!

On Fri, Nov 11, 2005 at 11:13:45PM -0300, Fabricio Mota wrote:
> Ok, I'll study these codes.
> 
> But I need to create 3 system tables in mysql database. These tables should
> manage persistent data, and make specific actions (specific code routines)
> when user try to insert, update or delete data into or from them. Do you
> think these codes you adviced me could answer these (new) questions?

I am not sure that it is right decision to add something to mysql
database. If you describe why you need that tables in mysql maybe I Will
agree with you, but now I have bad strong feeling about adding
something to mysql database.

To perform some actions on changing some special tables you have 2
options:
1) use triggers.
2) prohibit access direct access to that tables and use special
commands to update them (like CREATE/DROP PROCEDURE)

[skip]

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Oleksandr Byelkin <sanja@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Lugansk, Ukraine
       <___/   www.mysql.com