deeejay

psql - CRUD SQL

Dec 7th, 2015
373
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM data_load_status WHERE name = 'EDW' ORDER BY log_date DESC;
  2.  
  3. INSERT INTO data_load_status VALUES ('EDW', 'Stop', '2015-12-06 02:28:00.000');
  4.  
  5. UPDATE data_load_status SET log_date = '2015-12-07 02:28:00.000' WHERE log_date = '2015-12-06 02:28:00.000';
  6.  
  7. DELETE FROM data_load_status WHERE log_date = '2015-11-01 02:01:21.253';
Advertisement
Add Comment
Please, Sign In to add comment