Create Table in Database by sukanyaran98

VIEWS: 2 PAGES: 2

									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

								
To top