Postgres SQL queries

PHOTO EMBED

Fri Aug 09 2024 13:09:10 GMT+0000 (Coordinated Universal Time)

Saved by @StephenThevar

INSERT INTO tbl_users (user_id, username, crm_id, email, table_type, card_name) VALUES (1553,'Abhay Kumar', 'ak_531328', 'abhay.kumar1@tatamotors.com', 1, '1,2,4,5,6,13,14,15,19,16,17,21,18,29,32');
------------------------------------------
INSERT INTO tbl_users (user_id, username, crm_id, email, table_type, card_name, created_on) VALUES
(1555, 'RAMAN GUPTA', NULL, 'raman.gupta@tatamotors.com', 1, '1,2,4,5,6,13,14,15,19,16,17,21,18,29,32', CURRENT_TIMESTAMP),
----------------------------------------------
UPDATE tbl_users
SET username = 'Gaurav Yadav',
    crm_id = NULL,
    email = 'gaurav.yadav@tatamotors.com',
    table_type = 1,
    card_name = '1,2,4,5,6,13,14,15,19,16,17,21,18,29,32',
    created_on = CURRENT_TIMESTAMP
WHERE user_id = 1554;
--------------------------------------------
content_copyCOPY