2uzhan.com
Advertisement
Now Place:2uzhan.com » Metadata doubt..

Metadata doubt..

MySQL @ August 18, 2005   Views:0

I am using MySQL 4.1
How do i get the list of all tables,views,users,procedures etc
I want to know which dictionary table should i query in MySQL4.1

Thanks in advance
Shrimon

--------------Solutions-------------

You should upgrade if you're just doing some experimenting: http://dev.mysql.com/doc/mysql/en/news-5-0-x.html

...
The following changelog shows what has been done in the 5.0 tree:

Basic support for read-only server side cursors.

Basic support for (updatable) views. See, for example, Section 21.2, “CREATE VIEW Syntax”.

Basic support for stored procedures (SQL:2003 style). See Chapter 19, Stored Procedures and Functions.

Initial support for rudimentary triggers.
... Well the first thing to say is there are no procedures or views in 4.1.

For the rest you can use the show commands details here.

http://dev.mysql.com/doc/mysql/en/show.html

For users however you need to use the users tables like so.

select * from mysql.user;

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Tags:
© 2018 2uzhan.com Contact