/*
INTEGER

TinyInt - 1 bytes 
SmallInt - 2 bytes 
mediumInt - 3 bytes 
int - 4 bytes 
BigInt - 8 bytes

DECIMAL 

1. DATETIME - used for values that contains both date and time parts.
2. TIMESTAMP - used for values that contain both date and time parts.
*/

-- CREATING DATABASE 

-- Create database School; 

-- START DATABASE

-- Use School; 

-- CREATING TABLE 

create table Student(
    ID int(10) primary key auto_increment,
    Name text(30) not null, 
    Age int(4), 
    Email varchar(40),
    Marks decimal(6,3),
    DOB Date
    
);

-- DISPLAY THE STRUCTURE OF TABLE 

DESC Student; 
DESCRIBE Student;