LinuxQuestions.org - MySQL question

- Programming (https://www.linuxquestions.org/questions/programming-9/)

- - MySQL question (https://www.linuxquestions.org/questions/programming-9/mysql-question-29182/)

jISV	08-30-2002 03:42 PM

MySQL question

In oracle, I can run something like this..

PHP Code:




select TABLE_NAME, COLUMN_NAME, DATA_TYPE, OWNER from ALL_TAB_COLUMNS where USER = 'bill'.

Can someone tell me how I could do a similar thing in mysql?
Thanks.

MartBrooks

08-30-2002 04:37 PM

Perhaps I've missed the point: This is valid SQL, even MySQL should successfully complete the query.

What error are you seeing?

jISV	08-31-2002 02:27 PM

The problem is that oracle stores these details in the table all_tab_columns, so you can easily find out any information about database contents. This is what I'm trying to do. The result is shown.

PHP Code:




mysql> select table_name, column_name, data_type, owner from all_tab_columns;

PHP Code:




ERROR 1146: Table 'changemgmt.all_tab_columns' doesn't exist

I've looked, but I don't know where mysql holds similar type of information.

OldNewUser

09-06-2002 11:24 AM

Meta Data

In a quick look at MySQL documentation I thought this section might help you:

http://www.mysql.com/products/myodbc...ta_Information

It does not look as easy to do it under MySQL as in Oracle.

Just my 2 cents worth...

good luck

All times are GMT -5. The time now is 11:26 PM.