Project 1

Main SQL Query used to create database:-

1. CREATE DATABASE database_name;

This query is used for creating new database in MySQL Database.

2. CREATE TABLE table_name(firstcolumn_name datatype(length), secondcolumn_name datatype(length)....);

This query is used for creating new table in MySQL Database.

3. ALTER TABLE table_name ADD FORIEGN KEY(colmun_name ) REFFERENCE table_name.column_name;

This query is used for adding foriegn key by refference in MySQL Database.

4. ALTER TABLE table_name ADD PRIMARY KEY(colmun_name );

This query is used for adding primary key in MySQL Database.

ALTER is used for adding , droping, inserting, updating data in database.

and others.