hello; I am using my webhost's PHPMyAdmin console;
update table_A set col_1 = ( select col_1 from table_B ) // does not work
update table_A set col_1 = table_B.col_1 where ( table_A.col_# = table_B.col_# ) // does not work
any thoughts
thanks
dsdsdsdsd
copy column from one table to another
Moderator: General Moderators
hello;
I have managed to get:
to work on PHPMyAdmin 2.6.1-pl3 with MYSQL 4.0.16
but it will not work on PHPMyAdmin 2.6.0-pl3 with MYSQL 3.23.58;
any thoughts
thanks
Shannon Burnett
Asheville NC USA
I have managed to get:
Code: Select all
update table_A , table_B set table_B.col_1 = table_A.col_1 where table_B.col_# = table_A.col_#but it will not work on PHPMyAdmin 2.6.0-pl3 with MYSQL 3.23.58;
any thoughts
thanks
Shannon Burnett
Asheville NC USA
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
You didn't read far enough into the documentation... 
UPDATE wrote: Starting with MySQL 4.0.4, you can also perform UPDATE operations that cover multiple tables. The table_references part lists the tables involved in the join. Its syntax is described in Section 13.2.7.1, “JOIN Syntax”.