Tutorialsplane

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

admin

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’ ;

 

Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation
How to update row using joins in MYSQL | to updtae row ,data using joins in sql
How to import database using command line in MySQL
How to select database using command line in Mysql
My Sql Questions And Answers
Get last conversation in mysql table in facebook style
Mysql find duplicate records in table
Sql create table with primary key
Mysql create table primary key autoincrement example
Get zip codes in radius Mysql query
SQL Prevent Duplicate INSERT – MySql
Get list of MySQL user accounts
Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’
MySQL Grant all privileges on database