Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use employees;
- select * from employees
- where emp_no = '999903' ; #Here The Row Is Empty So I Inserted New Data
- insert into employees
- set
- emp_no = '999903',
- birth_date = '1997-02-09',
- first_name = 'Shon',
- last_name = 'Frost',
- gender = 'M',
- hire_date = '2019-07-25' ;
- insert into titles # titles is child table where related to employees which describes about the position of employee
- set
- emp_no = '999903',
- title = 'Data Scientist',
- from_date = '2019-07-25' ;
- commit ;
- delete from employees
- where emp_no = '999903' ;
- rollback ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement