is it working?

[Nathann33]

im working through the php tutorial on w3schools and im looking into the mysql tutorials. i used the code that they suggested to create a database called "my_db"next, i looked into creating a tablei tried using the code for creating a table just below the previous code. it returned "didnt work because this database has already been created"so i changed the name of the database to be created to "my_db2." this time, my_db2 was created right where i thought it would be, but its contents are the same as "my_db." is there any way to know if the table i created is there?thanks in advance

[justsomeguy]

The easiest way to manage your databases will be to use phpMyAdmin. It will give you a graphical interface of your databases and what they contain. Otherwise you will need to use a SQL query to get all of the table names, which I'm not sure of. You can probably find something like that through Google.

[scott100]

im working through the php tutorial on w3schools and im looking into the mysql tutorials.  i used the code that they suggested to create a database called "my_db"next, i looked into creating a tablei tried using the code for creating a table just below the previous code.  it returned "didnt work because this database has already been created"so i changed the name of the database to be created to "my_db2."  this time, my_db2 was created right where i thought it would be, but its contents are the same as "my_db."  is there any way to know if the table i created is there?thanks in advance

<{POST_SNAPBACK}>

USE my_db

To select the database

SHOW tables

To see all the tables in the db.Also to see info in the table, if it has any:

SELECT * FROM tablename

To see all the contents of the table name tablename