Check this out. http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
On 12/9/05, Sachin Bhugra <[EMAIL PROTECTED]> wrote: > Hello Friend, > > Can you please let me know how to copy data from a column in table A > to a column in table B. e.g. I want to copy value of column "age" from > table 2 to column "age" in table 1, provided the entries in column > "name", which is there in both the table, should match. In MySQL v 4 > it could be done using Update tbl1,tbl2 syntax, but i have now MySQL > 3.23 which does not supports this Update syntax... > > Also, can i use ldap to authenticate the MySQL users, if yes, please > tell me how?? > > Tnax. > > Sachin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]