Skip to content

Deprecation Warning: 'VALUES function' in ON DUPLICATE KEY UPDATE clause in MySQL 8.0.32 #162

Open
@shaan2610

Description

@shaan2610

Your Question

When attempting to run an INSERT query, I encountered the following warning message:

'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause
with alias.col
instead

I am currently using MySQL version 8.0.32, and I would like to know when support for this function will be removed and in which version this change will take effect.

The document you expected this should be explained

https://dev.mysql.com/worklog/task/?id=13325

Expected answer

When will the support for this function be removed ?

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions