> is it possible to get information about tables by doing queries on some
> tables? I am using mysql version 4.1.11 on debian sarge.
> In my case I need to know which columns (names and types) a table has, and
> the primary key is defined.
> How can I get this information out of mysql by only using sql ?
Have a look at the SHOW commands in the documentation.
As for system tables, MySQL 4.1 hardly has any.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!