How to update row using joins in MYSQL | to updtae row ,data using joins in sql

You can update row using joins in MYSQL as follows :

 

update TABLE_1 join TABLE_2  on   TABLE_1.id=TABLE_2.user_id SET  TABLE_1.name =”Test”  where TABLE_2.user_id=’12’ ;

 

Add Comment

📖 Read More

• 1. How to import database using command line in MySQL
• 2. How to select database using command line in Mysql
• 3. My Sql Questions And Answers
• 4. Get last conversation in mysql table in facebook style
• 5. Mysql find duplicate records in table

• 6. Sql create table with primary key
• 7. Mysql create table primary key autoincrement example
• 8. Get zip codes in radius Mysql query
• 9. SQL Prevent Duplicate INSERT - MySql
• 10. Get list of MySQL user accounts