INSERT values from one table to another with the new id and coping new id to another table

Asked Oct 30 '17 at 13:23

Active Oct 30 '17 at 13:26

Viewed 48 times

I have sql query:

INSERT INTO users (name, username, email, params, password )
SELECT CONCAT (`IMIE_WL`,' ', `NAZ_WL`), 
       CONCAT (a.wid,'-',LPAD(a.cid, 4, '0') ,'-',LPAD(a.LP_H, 2, '0')),
       b.AK_NAZWA,
       CONCAT('{"language":"","helpsite":""}'),
       CONCAT('SomePasswordSalted')
FROM   source_data AS b
INNER JOIN loginy AS a ON a.ID_LOK = b.ID_LOK;

I need add to this another insert to this query like this:

INSERT INTO conector (id,ID_LOK) VALUES (LAST_INSERT_ID(),ID_LOK);

Any ideas for one query?

edited Oct 30 '17 at 13:26

Juan Carlos Oropeza

47,252
12
78
118

asked Oct 30 '17 at 13:23

Sebastian Pachla

Possible duplicate of [LAST\_INSERT\_ID() MySQL](https://stackoverflow.com/questions/3837990/last-insert-id-mysql) – Juan Carlos Oropeza Oct 30 '17 at 13:27
1

Short answer: You can't merge two separated insert's into one query. – Raymond Nijland Oct 30 '17 at 13:29
I understand : can't use last_insert_id in my query. – Sebastian Pachla Oct 30 '17 at 14:23

INSERT values from one table to another with the new id and coping new id to another table

0 Answers0