Mysql

MySQL Database and Tables

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

Creating a database :

CREATE DATABASE  YOUR_DATABASE_NAME;

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

SHOW DATABASES;

Use an existing database using this query :

USE DATABASE_NAME;
  • 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 :

CREATE TABLE IF NOT EXISTS table_name(col type, col type)

e.g :

CREATE TABLE IF NOT EXISTS student (
  id int(8) NOT NULL,
  name varchar(8) NOT NULL,
  rollno int(10) NOT NULL
);

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

EXPLAIN table_name;
DESCRIBE table_name;

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

DROP TABLE table_name;

Recommended Tutorials for you


Related posts

MySQL Data Type

Anuj Kumar

MySQLi Procedural Functions

Anuj Kumar

How to use mysql through cmd

Anuj Kumar

MySQL Select Query

Anuj Kumar

MySQL Command-line

Anuj Kumar

MySQL Column Modifiers

Anuj Kumar

How to Connect php with mysql Database

Anuj Kumar

MySQL Introduction

Anuj Kumar

MySQL PHP Connections

Anuj Kumar

Leave a Comment

* By using this form you agree with the storage and handling of your data by this website.

This site uses Akismet to reduce spam. Learn how your comment data is processed.