> For the complete documentation index, see [llms.txt](https://roshan-kr-grg.gitbook.io/blog/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://roshan-kr-grg.gitbook.io/blog/programming/database/update-with-join-in-mysql.md).

# Update with join in mysql

```
// Some code
UPDATE tableA ta 
JOIN tableB tb on ta.column = tb.column
SET ta.column = "random"
WHERE ta.column = "where1" AND tb.column = "where2";


```