CREATE Statement on MYSQL

Create Database

Now let’s see how we can create a new database. However, we can’t create duplicate database with the same name of an existing database.

Syntax:

CREATE DATABASE databasename;

Query:

create database testdb;

Output:

New database ‘testdb’ will be created

As you see above, we have just created a new database

Tester Usage Tips:

• Create a new database for test data storage
• Create a new database as backup of application database for testing
• Create temporary database for testing ETL or Reports.

 

Create Table

Now as we have a database, we need to create a table to store and manipulate our required data.

Simply put table is nothing but a combination of rows and columns

Let’s create a new table by the name ‘Persons’ where we would want to store and manipulate a person’s basic demographics information.

Syntax:

USE databasename

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ….
);

Query:

USE employees

CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

Output:

‘Persons’ table will be created with mentioned columns as above.

As you see above new table ‘Persons’ is created with specified columns

Tester Usage Tips:

• Create a new table for application data or test data storage and manipulation