[sql] practefe
Viewer
- CREATE DATABASE ORG;
- SHOW DATABASES;
- USE ORG;
- CREATE TABLE Worker (
- WORKER_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
- FIRST_NAME CHAR(25),
- LAST_NAME CHAR(25),
- SALARY INT(15),
- JOINING_DATE DATETIME,
- DEPARTMENT CHAR(25)
- );
- INSERT INTO Worker
- (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES
- (001, 'Monika', 'Arora', 100000, '14-02-20 09.00.00', 'HR'),
- (002, 'Niharika', 'Verma', 80000, '14-06-11 09.00.00', 'Admin'),
- (003, 'Vishal', 'Singhal', 300000, '14-02-20 09.00.00', 'HR'),
- (004, 'Amitabh', 'Singh', 500000, '14-02-20 09.00.00', 'Admin'),
- (005, 'Vivek', 'Bhati', 500000, '14-06-11 09.00.00', 'Admin'),
- (006, 'Vipul', 'Diwan', 200000, '14-06-11 09.00.00', 'Account'),
- (007, 'Satish', 'Kumar', 75000, '14-01-20 09.00.00', 'Account'),
- (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin');
- CREATE TABLE Bonus (
- WORKER_REF_ID INT,
- BONUS_AMOUNT INT(10),
- BONUS_DATE DATETIME,
- FOREIGN KEY (WORKER_REF_ID)
- REFERENCES Worker(WORKER_ID)
- ON DELETE CASCADE
- );
- INSERT INTO Bonus
- (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES
- (001, 5000, '16-02-20'),
- (002, 3000, '16-06-11'),
- (003, 4000, '16-02-20'),
- (001, 4500, '16-02-20'),
- (002, 3500, '16-06-11');
Editor
You can edit this paste and save as new:
File Description
- practefe
- Paste Code
- 02 Mar-2021
- 1.25 Kb
You can Share it:
Latest Code Pastes