CODEWITHSUNDEEP
mysqlupdate-inner-join
hiago cardoso
hiago cardoso

Reputation: 11

UPDATE with INNER JOIN phpmyadmin

UPDATE icmsc100 SET codigo='test'
FROM icmsc100
INNER JOIN icms307
ON icms307.ajusteDeCodigo = icmsc100.codigoItem;

I'm trying to use it this way, but it's returning an error, how should it be done?

Error #1064 - Syntax Error

Upvotes: 0

Views: 422

Answers (1)

Kajal Panda
Kajal Panda

Reputation: 26

You can update the data with the Inner Join In MYSQL as below.

UPDATE icmsc100 
INNER JOIN icms307 
ON icms307.ajusteDeCodigo = icmsc100.codigoItem
SET codigo='test';

Upvotes: 1

Related Questions