Direct cmd command mode using
| The code is as follows |
Copy Code |
show databases;
Show tables from db_name;
Show columns from table_name to db_name;
Show index from Talbe_name [from db_name]; Show status;
Show variables; Show [Full] processlist;
Show table status [from db_name]; Show grants for user; |
Combined with PHP MySQL database
| code is as follows |
copy code |
| $server = ' localhost ';
$user = ' root ';
$pass = ';
$dbname = ' dayanmei_com ';
$conn = mysql_connect ($server, $user, $pass);
if (! $conn) Die ("Database system Connection Failed! ");
mysql_select_db ($dbname) or Die (" database connection failed!). ");
$result = mysql_query (" Show TABLES "),
while ($row = Mysql_fetch_array ($result))  &NBSP
{
echo $row [0]. "";  &NBSP
Mysql_free_result ($result); |
Note the function Mysql_list_tables of all table names in the list MySQL in PHP, has been deleted, we recommend that you do not use the function list MySQL datasheet
