You can also use these to get other useful information:
Code:SHOW TABLES; /* return a recordset with a list of tables in the current DB */ SHOW DATABASES; /* return a recordset with a list of databases on the server */ USE dbname; /* begin using a different database */




Reply With Quote