NFD Posted October 28, 2006 Share Posted October 28, 2006 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 :) Quote Link to comment Share on other sites More sharing options...
pendelton Posted October 29, 2006 Share Posted October 29, 2006 Have you tried using phpmyadmin to see what is going on? Quote Link to comment Share on other sites More sharing options...
corbin Posted October 29, 2006 Share Posted October 29, 2006 UPDATE `table1` SET `test_id` = 'table2.test_id' WHERE `table1.group` = 'table2.group';I doubt thats it, but worth a try :P. Quote Link to comment Share on other sites More sharing options...
Barand Posted October 29, 2006 Share Posted October 29, 2006 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.