create

LastName	FirstName	Address	City
ABC	EFG	1,First St	Chicago
XYZ	EFG	3,Second St	New York
EFG	ABC	2,Third St	Indianapolis

CREATE

The CREATE statement is used to create a database or
a table.
To create a database we use the following syntax

CREATE DATABASE <database name>

To create a table in the database we use the CREATE
TABLE query. The syntax for the CREATE TABLE query
is

CREATE TABLE <table name> (column name1 data
type, column name2 data type, column name3 data
type....)

The below example creates a table called Student with
the fields LastName, FirstName, Address, City.

CREATE TABLE Student (LastName varchar, FirstName
varchar, Address varchar, City varchar)

SQL Queries