MySQL Database and Tables

0

- Advertisement -

This tutorial demonstrates how to SQL statement that creates MySQL database tables in which  to store data.
A simple database table look like this  :
SQL table

Creating a database :

In MySQL  you can display a list of all databases by using this query :

Use an existing database using this query :

  • The SHOW TABLES; query used to display a list of all tables in a database, if this query return a “empty set” message there are no table in the database.

Creating tables :

A MySQL table is created by this query :

e.g :

You can discover  the format of any table by using these two queries :

Both query will return same result.
A table may also be deleted from a database with this query :

- Advertisement -

Leave A Reply

Your email address will not be published.