15/05/2017

DATABASE

   A database is a collection of information that is organized so that it can be easily accessed, managed and updated.

1.create a database
 create database databasename; 

2. drop a database
  drop database databasename;

3.create table

create table table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
  
);

4.drop table
drop table table_name;

5.alter table
The alter table statement is used to add, delete, or modify columns in an existing table.
     1.alter table table_name
        add column_name datatype; 

     2.alter table table_name
        drop column column_name;