Jump to content

Archived

This topic is now archived and is closed to further replies.

NFD

A Simple SQL Update Via PHP

Recommended Posts

Hi,

What I am trying to do is update one field on one table based upon a match of anoother field on another table.

Here is my initial query (at this stage entered via phpmyadmin):
UPDATE `table1` SET `test_id` = 'table2.test_id' WHERE `group` = 'table2.group' ;

Whilst the query itself runs, it affects 0 rows which is unexpected as there are 2000+ matches.

Firstly I need to know what part of the query am I doing incorrectly?

Afterwards, I want to have a go at making it a query run as part of a php file that does alot of data inserts first.

Any help that can be given would be much appreciated :)

Share this post


Link to post
Share on other sites
UPDATE `table1` SET `test_id` = 'table2.test_id' WHERE `table1.group` = 'table2.group';

I doubt thats it, but worth a try :P.

Share this post


Link to post
Share on other sites
I think it's
[code]
UPDATE `table1`, `table2`
SET `table1`.`test_id` = `table2`.`test_id`
WHERE `table1`.`group` = `table2`.`group`;
[/code]
BTW, "group" isn't a good choice of column name as it's a MySQL reserved word

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.