MySql example
CREATE TABLE EMPLOYEE ( Emp_NO INTEGER PRIMARY KEY, Emp_Name TEXT NOT NULL, Emp_Add TEXT NOT NULL, Emp_Phone TEXT NOT NULL, Dept_No TEXT NOT NULL, Dept_Name TEXT NOT NULL, Salary TEXT NOT NULL ); -- insert INSERT INTO EMPLOYEE VALUES (0001, 'Ramesh', 'GNoida','9855498465', '3445', 'Sales','25000'); INSERT INTO EMPLOYEE VALUES (0002, 'Suresh', 'GNoida','98565498465', '0072', 'Sales','75000'); INSERT INTO EMPLOYEE VALUES (0003, 'Rajesh', 'GNoida','9855497865', '2324', 'Sales','28000'); update EMPLOYEE SET Emp_Add='Mathura' where Emp_No=3; ALTER table EMPLOYEE ADD Job_ID INT; SELECT * FROM EMPLOYEE ; .exit ;
MySql example 2
-- create CREATE TABLE PRODUCTS ( pId INTEGER PRIMARY KEY NOT NULL, item TEXT , price MONEY ); INSERT INTO PRODUCTS VALUES(1,"PEN",1.20); INSERT INTO PRODUCTS VALUES(2,"PENCIL",2.20); INSERT INTO PRODUCTS VALUES(3,"BOOK",5.20); --alter TABLE ALTER TABLE PRODUCTS ADD cId INTEGER; --fetch again UPDATE PRODUCTS SET cId = 0001 WHERE pId = 1; UPDATE PRODUCTS SET cId = 0002 WHERE pId = 2; UPDATE PRODUCTS SET cId = 0003 WHERE pId = 3; INSERT INTO PRODUCTS VALUES(4,"","",004); --delete DELETE FROM PRODUCTS WHERE pId = 4; --fetch SELECT cId FROM PRODUCTS; SELECT item FROM PRODUCTS; --count SELECT COUNT(pId) FROM PRODUCTS; --avg SELECT AVG(price) FROM PRODUCTS; INSERT INTO PRODUCTS VALUES(4,"BOX","10.20",0004); --count SELECT COUNT(pId) FROM PRODUCTS; --Search SELECT item FROM PRODUCTS WHERE item LIKE 'P%'; CREATE TABLE CUSTOMERS( cId INTEGER PRIMARY KEY NOT NULL, product TEXT, price MONEY ); INSERT INTO CUSTOMERS (cId, product, price) SELECT cId,item,price FROM PRODUCTS; SELECT price FROM CUSTOMERS ORDER BY price DESC; -- fetch SELECT * FROM PRODUCTS; --fetch SELECT * FROM CUSTOMERS;