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?
Thank you, Oleksandr.
FM
-----Mensagem original-----
De: Sanja Byelkin [mailto:sanja@stripped]
Enviada em: sexta-feira, 11 de novembro de 2005 04:57
Para: Fabricio Mota
Cc: internals@stripped
Assunto: Re: System Tables
Hi!
On Thu, Nov 10, 2005 at 09:43:42PM -0300, Fabricio Mota wrote:
> Hi All,
[skip]
> I've searched where is the management of system tables in MySQL, but the
> only thing I've found was a test source code file that creates the system
> tables for tests. But no access management I've fould (such as data
> retrieval, insertion, updating or deletion for system management).
> Anybody can help me?
Mysql have not so much system tables, all they collected into mysql
database. there are tables of ACL system (see sql/sql_acl.*), table to
store "stored procedures" (see sql/sp_head.* sql/sp.*) and help
information. All other information stored into so-called .frm file. one
file per table. there are two formats of that files old - for base
tables (see sql/sql_base.cc sql/unireg.cc sql/table.*) and new one
(just a text) for storing view information (sql/sql_view.cc
sql/table.*).
To show all this information mysql use SHOW command family and
INFORMATION SCHEMA, both can be found into sql/sql_show.*
Some engines have its own meta-information about tables, it is innodb
and ndb for example.
I hope I answered your question.
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin <sanja@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com
