Home Sql Sqlbeginner Create Table in Database
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Create Table in Database

Advertisement
The objects in a Relational database System is called Tables. The Tables contain the information on data for the database.

Create Table in Database

     

The objects in a Relational database System is called Tables. The Tables contain the information on data for the database. Each Table in a database is uniquely identified  by their names. It comprised of columns and rows. The column in a table contain the name of column, data type and attribute incase used in column. Columns in a Table are also called Field. The Rows contains the set of records and data for the columns. Rows in a Table are  Tuple.The collection of rows and column collectively called  cell in a Table. 

Understand with Example

The Tutorial illustrates you a simple example for the beginners, to create a table in database. In this Tutorial, we are using MySQL command query to create a table in database name countryinfo.

The create database is used to create database name countryinfo.

The use is used to show  the database

The create table is used to create a table name country in database

The show table is used to display the table name in database. 

create database countryinfo;

Output is displayed as

Output is displayed as

  use countryinfo;

create table country(countryname varchar(15),countrycapital varchar(15));

 Output is displayed as

  show tables;

 Output is displayed as

Download Source

Advertisements

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 12, 2008

Ask Questions?    Discuss: Create Table in Database   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
amelia drotini
April 16, 2012
project

how do you create table in database?
Eswar
April 20, 2012
About sql

how to run crete.txt file?
damanpreet kaur pruthi
May 17, 2012
computer

it is best
DMCA.com