How to Update MYSQL database table based on mysql query array?

Question

I am trying to update a table based on a mysql query of another table in the same database. I can use
$con = mysql_connect("server","database","%*&^(*&(*&");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("database", $con);


mysql_query("UPDATE data SET Column_name = 'Value'
WHERE column_name = **value in another table** ");


mysql_close($con);
?>

to change the value based on a set value i put in the code. But does anyone know what I should do to get the value to be based on a query of another table?

thanks

Answer 1

Experiment and find out.

Without my experimenting I do not see why not as long as the value selection returns only one value.

It is common in my work to load a test table from production using syntax such as: insert into table_x (select * from table_x@prod_db);

Answer 2

Wouldn't you just put the value of the other table? Maybe you should explain more.