I'm trying to do SQL query to my DB. It must search for a row with the username in table1 and copy its id to a column in table2.
Search for user "John" in table1 and copy John's id to table2
id | username | points
id | user_id
I'm actually tried this:
INSERT INTO table2(table2.user_id) SELECT table1.id WHERE table1.username = "John";
Can you try this?
INSERT INTO table2 (user_id) SELECT t1.id FROM table1 AS t1 WHERE t1.username = 'John';
Note : This will work if column id on table1 is an identity (running number).