[sql] PROJ-SCRIPTS-FMCGGLOABAL
Viewer
- CREATE DATABASE `FMCGGLOBAL;
- USE FMCGGLOBAL;
- CREATE TABLE EMPLOYEES(EMPLOYEE_ID CHAR(5) PRIMARY KEY,EMPLOYEE_NAME CHAR(50),BIRTH_DATE DATE, TITLE CHAR(60),HIRE_DATE DATE,CONTACT_NO BIGINT);
- INSERT INTO EMPLOYEES VALUES('E001','KARTHIKA','1999-09-17','SALES MANAGER','2015-03-07','9123434567');
- INSERT INTO EMPLOYEES VALUES('E002','KAMALI','1998-01-02','EXCECUTIVE OFFICER','2000-11-18','0987654321');
- INSERT INTO EMPLOYEES VALUES('E003','PRABHA','1996-06-12','CUSTOMS MANAGER','2016-12-09','1234567890');
- INSERT INTO EMPLOYEES VALUES('E004','SUDHA','1993-04-26','PRODUCT MANAGER','2019-06-02','123456123456');
- INSERT INTO EMPLOYEES VALUES('E005','SANDHIYA','1990-11-28','CASHIER','2014-08-23','2456782910');
- SELECT * FROM EMPLOYEES;
- CREATE TABLE SUPPLIERS(SUPPLIER_ID CHAR(5),SUPPLIER_NAME CHAR(70) ,ADDRESS VARCHAR(80),CONTACT_NO BIGINT);
- INSERT INTO SUPPLIERS VALUES('S001','MANI','NO-8,SABRAI TOWERS,KARAIKUDI','2345678901');
- INSERT INTO SUPPLIERS VALUES('S002','SARVESH','NO-8,WEST SITE,SALEM','11122334455');
- INSERT INTO SUPPLIERS VALUES('S003','SREEKANTH','NO-2,PALAK TOWERS ,ANDHRA','9999911111');
- INSERT INTO SUPPLIERS VALUES('S004','PAVITHRA','NO-9,NAVIN TOWERS,CHENNAI','0902324441');
- INSERT INTO SUPPLIERS VALUES('S005','SAKTHI','NO-6,GANDHI ROAD,MADURAI','12345678890');
- SELECT * FROM SUPPLIERS;
- CREATE TABLE CUSTOMERS(CUSTOMER_ID CHAR(5) PRIMARY KEY,CUSTOMER_NAME CHAR(50), ADDRESS VARCHAR(50),CONTACT_NO BIGINT);
- INSERT INTO CUSTOMERS VALUES('C001','PRIYA','2-EAST COAST ROAD -CHENNAI','34353627289');
- INSERT INTO CUSTOMERS VALUES('C002','AHILA','4-WEST COAST ROAD -ALANDUR','34353627289');
- INSERT INTO CUSTOMERS VALUES('C003','ABHI','6-NORTH COAST ROAD MYLAPORE','34353627289');
- INSERT INTO CUSTOMERS VALUES('C004','SUHI','8-SOUTH COAST ROAD MAANGADU','34353627289');
- INSERT INTO CUSTOMERS VALUES('C005','SUMI','10-EAST -WEST COAST ROAD-SAIDAPET ','34353627289');
- SELECT * FROM CUSTOMERS;
- drop table products;
- CREATE TABLE PRODUCTS(PRODUCT_ID CHAR(5)PRIMARY KEY,PRODUCT_NAME CHAR(50),PRICE int,AVAILABLE_QUANTITY INT,EXPIRY_DATE DATE, SUPPLIER_ID CHAR(5),CUSTOMER_ID CHAR(5),REORDER_LEVEL INT,REMARKS CHAR(6));
- INSERT INTO PRODUCTS VALUES('P001','BISCUIT',123,5,'2024-01-18','S001','C001',10,'YES');
- INSERT INTO PRODUCTS VALUES('P002','SALT',19,5,'2022-02-17','S002','C002',7,'NO');
- INSERT INTO PRODUCTS VALUES('P003','CLASSMATE-NOTE',125,5,'2026-03-23','S003','C003',6,'YES');
- INSERT INTO PRODUCTS VALUES('P004',' HIMALAYAS-LIPSTICK',80,5,'2025-04-19','S004','C004',8,'NO');
- INSERT INTO PRODUCTS VALUES('P005','LUX SOAP',45,5,'2023-01-28','S005','C005',25,'YES');
- describe products;
- SELECT * FROM PRODUCTS;
- CREATE TABLE CATEGORIES(CATEGORY_ID CHAR(6) PRIMARY KEY,CATEGORY_NAME VARCHAR(60),DESCRIPTION CHAR(30));
- INSERT INTO CATEGORIES VALUES('CY001','FOOD','HEALTHY CONTENT');
- INSERT INTO CATEGORIES VALUES('CY002','HOME NEEDS','HEALTHY MUST IMPORTANT');
- INSERT INTO CATEGORIES VALUES('CY003','STATIONARY','CLASS PAPERS');
- INSERT INTO CATEGORIES VALUES('CY004','COSMETICS','NO DEMAGE');
- INSERT INTO CATEGORIES VALUES('CY005','CLEANING','NICE FRAGRANCE');
- SELECT * FROM CATEGORIES;
- CREATE TABLE ORDERS(ORDER_ID CHAR(5) PRIMARY KEY,CUSTOMER_ID CHAR(5),EMPLOYEE_ID CHAR(5),ORDER_DATE DATE,REQUIRED_DATE DATE,SHIPPED_DATE DATE,SHIIPING_ADDRESS VARCHAR(80));
- INSERT INTO ORDERS VALUES('O001','C001','E001','2022-01-18','2022-01-25','2022-01-30','N0-1,MARKET ROARD-PALANI');
- INSERT INTO ORDERS VALUES('O002','C002','E002','2021-02-23','2022-07-26','2022-06-20','N0-2,RAIDS ROARD-DINDIGUL');
- INSERT INTO ORDERS VALUES('O003','C003','E003','2020-04-25','2022-09-27','2022-08-10','N0-3,SCHOOL ROARD-COIMBATORE');
- INSERT INTO ORDERS VALUES('O004','C004','E004','2018-06-09','2022-03-28','2022-09-25','N0-4,BANK ROARD-SINGAPORE');
- INSERT INTO ORDERS VALUES('O005','C005','E005','2019-05-15','2022-02-23','2022-03-28','N0-5,TOWERS ROARD-AMERICA');
- SELECT * FROM ORDERS;
- CREATE TABLE ORDER_DETAILS(ORDER_ID CHAR(5) PRIMARY KEY,PRODUCT_ID CHAR(5),QUANTITY INT(60),DISCOUNT INT(20));
- INSERT INTO ORDER_DETAILS VALUES('O001','P001','12','10');
- INSERT INTO ORDER_DETAILS VALUES('O002','P002','22','20');
- INSERT INTO ORDER_DETAILS VALUES('O003','P003','89','30');
- INSERT INTO ORDER_DETAILS VALUES('O004','P004','82','40');
- INSERT INTO ORDER_DETAILS VALUES('O005','P005','60','50');
- SELECT * FROM ORDER_DETAILS;
- CREATE TABLE PAYMENT_DETAILS(PAYMENT_ID CHAR(5) PRIMARY KEY,ORDER_ID CHAR(5),AMOUNT FLOAT,PAYMENT_DATE DATETIME,PAYMENT_TYPE CHAR(60));
- INSERT INTO PAYMENT_DETAILS VALUES('PY001','O001','2000.09','2022-03-19 09:43:23','DEBIT-CARD');
- INSERT INTO PAYMENT_DETAILS VALUES('PY002','O002','4000.89','2022-04-29 08:33:13','CREDIT-CARD');
- INSERT INTO PAYMENT_DETAILS VALUES('PY003','O003','6000.23','2022-05-12 07:23:19','NET-BANKING');
- INSERT INTO PAYMENT_DETAILS VALUES('PY004','O004','1000.19','2022-06-15 06:13:10','CASH-0N-DELIVERY');
- INSERT INTO PAYMENT_DETAILS VALUES('PY005','O005','8000.49','2022-07-10 04:83:12','GOOGLE-PAY');
- SELECT * FROM PAYMENT_DETAILS;
- describe table products;
- DELETE FROM PRODUCTS WHERE PRODUCT_ID='poo1';
Editor
You can edit this paste and save as new: