Mysql data structure. IT & Computer Science Article (Article Sample)

MySql table structure
Julie Jonus
Introduction
This paper defines creating a new SQL database and then creating the table in the database. We will study how to create a table in a database using MySQL command. The database will be based on the relational model. The objective of the paper is to create a table and define fields explaining its usage. We will also study a new feature that is auto-increment. For this the create table command is used to create a table in a database. The three things are needed to create the new table and that is
* Name of the table
* Field names
* Each field definition
Syntax:
Create table table_name (column_name column_type..);
The database name is world_x so:
Use world_x
CREATE TABLE independence (
id int NOT NULL AUTO_INCREMENT ,
Country_name varchar(50),
Independence_date date ,
PRIMARY KEY (id)