deeejay icon

psql - CRUD SQL

deeejay | PRO | 12/07/15 04:15:59 PM UTC | 0 ⭐ | 325 👁️ | Never ⏰ | []
PostgreSQL |

340 B

|

None

|

0 👍

/

0 👎

SELECT * FROM data_load_status WHERE name = 'EDW' ORDER BY log_date DESC;
 
INSERT INTO data_load_status VALUES ('EDW', 'Stop', '2015-12-06 02:28:00.000');
 
UPDATE data_load_status SET log_date = '2015-12-07 02:28:00.000' WHERE log_date = '2015-12-06 02:28:00.000';
 
DELETE FROM data_load_status WHERE log_date = '2015-11-01 02:01:21.253';

Comments