使用where子句mysql将数据从一个表传输到另一个表

Question

I would like to copy data from one table to another, but placing it in a specific row. The variable is set, the tables and query are named correctly and the columns set up correctly.

I would like to select the data circled in black

and place it within the section circled below in black

The query I am using if below. When it runs without the WHERE clause it goes on the row below, when the WHERE clause is added it is blank.

$query = "INSERT INTO Results (Q1A) SELECT Q1AY FROM Answers WHERE User = $email";

Answer 1

Try

$query ="UPDATE Results R SET Q1A= (SELECT Q1AY FROM Answers) WHERE R.User=$email"

This only works if there are only one row in Answers, but your code seems to assume as much.