0

I can see in the log from my MySQL server that values() is going to be removed in future release...

How can I avoid values() after "on duplicate key update" when I have multiple values to insert to a table?

I have this example:

insert into my.table (id,text) values (1,'hello world'),(2,'hello again') on duplicate key update text=values(text);

How should that be written if I cant use "values(text)" but still want to insert 2 rows?

Thanks.

dannielsen
  • 69
  • 1
  • 5

0 Answers0