MySQL question

jISV · 08-30-2002, 03:42 PM

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' doesnt exist

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

OldNewUser · 09-06-2002, 11:24 AM

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