Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. use employees;
  2.  
  3. select * from employees
  4. where emp_no = '999903' ; #Here The Row Is Empty So I Inserted New Data
  5.  
  6. insert into employees
  7. set
  8. emp_no = '999903',
  9. birth_date = '1997-02-09',
  10. first_name = 'Shon',
  11. last_name = 'Frost',
  12. gender = 'M',
  13. hire_date = '2019-07-25' ;
  14.  
  15. insert into titles # titles is child table where related to employees which describes about the position of employee
  16. set
  17. emp_no = '999903',
  18. title = 'Data Scientist',
  19. from_date = '2019-07-25' ;
  20.  
  21. commit ;
  22.  
  23. delete from employees
  24. where emp_no = '999903' ;
  25.  
  26. rollback ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement