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;
--------------------------------------------
Comments