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)
)
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Current Comments
3 comments so far (post your own) View All Comments Latest 10 Comments:The examples are simple and easy to understand.
Thanks alot.
Posted by AMOS OJIMAM on Wednesday, 05.21.08 @ 20:19pm | #60605
hello sir,
the explaNATION WHAT YOU MADE IS VERY NICE.. THANK U FOR GIVING US SUCH A NICE EXPLANATION
Posted by rajeswari on Saturday, 03.1.08 @ 17:09pm | #50853
Hello sir,
The way you are explaining is really good.
Posted by Uday on Friday, 02.1.08 @ 00:22am | #46766