Mysql访问其他用户.... [英] Mysql access other users....

问题描述

我已成功登录mysql数据库。当我运行mysql查询

  SELECT   user   FROM  mysql。 user  

It显示像许多用户：。MY_DATABASE，dba_upload，db_reg等等

我目前登录MY_DATABASE

我的问题是如何访问dba_upload的表和列<。 BR />
是否有任何MySQL查询，可以帮助我..

感谢。

解决方案

<预LANG = SQL>显示列 FROM dba_upload;

http://dev.mysql.com/doc/refman/5.0/en/show-columns.html [ ^ ]

I am logged in mysql database successfully. And when i run mysql query

SELECT user FROM mysql.user

It shows many user like: my_database, dba_upload, db_reg and many more.
I am currently logged in my_database.
My question is how to access tables and columns of dba_upload.
Is there any Mysql query that can help me..
Thanks.

解决方案

SHOW COLUMNS FROM dba_upload;

http://dev.mysql.com/doc/refman/5.0/en/show-columns.html[^]

这篇关于Mysql访问其他用户....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！