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;
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) )
Rs. 20,000 US$ 300
Today: Rs. 10,000 US$150
Course Duration: 30 hrs
Posted on: April 18, 2011 If you enjoyed this post then why not add us on Google+? Add us to your Circles