DbLab2 (Create table,where,insert,update,add column)

CREATE DATABASE lab3;

USE lab3;

CREATE TABLE student
(
name VARCHAR(50),
std_id VARCHAR(50),
semester VARCHAR(50),
YEAR VARCHAR(10),
age INT,
address VARCHAR(100),
city VARCHAR(20)
);

INSERT INTO student(name,std_id,semester,YEAR,age,address,city)
VALUES ('robi','14.02.04.084','1st','3rd',22,'motijheel','dhaka');

SELECT * FROM student;

SELECT * FROM student WHERE city='dhaka';

SELECT * FROM student WHERE age>18;

ALTER TABLE student
ADD  adviser_id INT;

INSERT INTO student(adviser_id)
VALUES (10);

INSERT INTO student(name,std_id,semester,YEAR,age,address,city)
VALUES ('robi','14.02.04.084','2nd','3rd',22,'motijheel','dhaka');

UPDATE student
SET age=26
WHERE city = 'dhaka'
AND YEAR='3rd';