INSERT SELECT to Another table with select column and custom data SQL

just doing this shit broh

INSERT INTO table_2
(id_user, id_random, email, status, tgl_terima, tgl_kirim, randomid)
SELECT 
'iduser123', id_random, 'email@domain.com', 0, NOW(), null, CONCAT(md5('iduser123',id_random) 
FROM table_1

for explaining just look above structure

Advertisements