MySQL problem
Moderator: General Moderators
MySQL problem
I've created a database, with one table in, but I don't remember what it's called! Is there any way do view this? Like an interface or so? 
use mysql command line tool:
Code: Select all
weirdan@home:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.14
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+-----------+
| Database |
+-----------+
| books |
| mysql |
| profiling |
| test |
+-----------+
4 rows in set (0.06 sec)
mysql> use test
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| ltest |
| newuser |
| tram |
+----------------+
3 rows in set (0.01 sec)or install phpMyAdmin which is a GUI for MySQL databases 
just adding to wierdan :
the instructions on how to use the command line tool and all of the options for displaying table or database information is located in your MANUAL that's included in teh directory you installed mysql.
if you are on windows, and installed mysql to c:\mysql
then your manual will be in c:\mysql\docs\manual.html
scroll down to about section 3.1 and it will show you all the things you need to know, including the beginning syntaxes you should become familiar with.
also good to know if the manual localed on http://www.mysql.com
the instructions on how to use the command line tool and all of the options for displaying table or database information is located in your MANUAL that's included in teh directory you installed mysql.
if you are on windows, and installed mysql to c:\mysql
then your manual will be in c:\mysql\docs\manual.html
scroll down to about section 3.1 and it will show you all the things you need to know, including the beginning syntaxes you should become familiar with.
also good to know if the manual localed on http://www.mysql.com