show DATABASES

use ecom

show tables

CREATE TABLE employee(ID INT PRIMARY KEY, First_Name VARCHAR(20), Last_Name VARCHAR(20), Salary INT, Email_Id VARCHAR(40));

INSERT INTO employee(ID, First_Name, Last_Name, Salary, Email_Id) VALUES(1, "Neeta", "Korade", 59000, "[email protected]"),

(2, "Sushma", "Singh", 62000, "[email protected]"),

(3, "Kavita", "Rathod", 27000, "[email protected]"),

(4, "Mrunalini", "Deshmukh", 88000, "[email protected]"),

(5, "Swati", "Patel", 34000, "[email protected]"),

(6, "Laxmi", "Kadam", 44000, "[email protected]"),

(7, "Lalita", "Shah", 66000, "[email protected]"),

(8, "Savita", "Kulkarni", 31000, "[email protected]"),

(9, "Shravani", "Jaiswal", 38000, "[email protected]"),

(10, "Shweta", "Wagh", 20000, "[email protected]");

SELECT *FROM employee;

DELETE FROM employee WHERE Salary = 34000;

SELECT *FROM employee WHERE Salary > 35000;

UPDATE employee SET Last_Name = "Bose" WHERE ID = 6;