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
.
Example: Search for user "John"
in table1
and copy John's id to table2
:
table1:
id | username | points
table2:
id | user_id
I'm actually tried this:
INSERT INTO table2(table2.user_id) SELECT table1.id WHERE table1.username = "John";
But its not working. I don't have an idea how to do that? Could you help me?