![mysql](https://habrastorage.org/r/w120/webt/5b/53/d5/5b53d5517cb34636505650.png)
MySQL
- 7 ответов
- 0 вопросов
5
Вклад в тег
UPDATE products p
JOIN update_info ui ON t.id = ui.id
SET p.price = ui.price
Warning
Never, never, NEVER use Python string concatenation (+) or string parameters interpolation (%) to pass variables to a SQL query string. Not even at gunpoint.