Create a database

In this section, we will teach you to create a database.

First of all, display all databases by show databases. This helps to find out the existing database. Then create a database using the given syntax and give the suitable name of database.

CREATE DATABASE database_name;

Then create connection with database. The connection is included in the names of the database.

Create a Table: the following query creates a table

CREATE TABLE table_name
(
column_name1 data_type,
.......
)

Yet the table does not have any data.

In the given example we show the use of the create to make a table email and populate it with the field named LName, FName and email_add.

CREATE TABLE email
(
LName varchar(20),
FName varchar(20),
email_add varchar(40)
)

Related Tags for Create a database:
c, database, syntax, table, data, ui, help, find, display, name, using, this, create, tab, show, databases, to, base, sh, e, it, ax, spl, first, in, as, m, nt, out, play, ps, sti, isp, es, tax, ase, all, me, how, s, su, sp, at, is, ir, ll, iv, ea, existing, and, xi, s, s, th, sho, st, ab, abl, exi, disp, fin, pl, nd, o

«Previous Index Next»