MySQL PHP Insert Update on duplicate key with varchar value

Asked Jun 11 '19 at 10:04

Active Jun 11 '19 at 10:14

Viewed 35 times

This is my code that works OK:

$stmt = $mysqli->prepare("INSERT INTO a (b1, b2, b3, b4) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE b3 = b3 + 1;");
$arr = explode(',', $query); 
$stmt->bind_param("ssss",$arr[0],$arr[1],$arr[2],$arr[3]);
$stmt->execute();             
$stmt->close();

I need to update incrementally b3 (works fine, it is int value) and additionally insert a new value to b4 (it is varchar). This does not work:

$stmt = $mysqli->prepare("INSERT INTO a (b1, b2, b3, b4) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE b3 = b3 + 1, b4 = VALUES(b4);");

My key is b1 and b2

edited Jun 11 '19 at 10:10

asked Jun 11 '19 at 10:04

Annabelle

1

define "does not work" – Your Common Sense Jun 11 '19 at 10:08
1

it is values(), not value() – Your Common Sense Jun 11 '19 at 10:09
no result - increment and new value is not changed (both are not updated) – Annabelle Jun 11 '19 at 10:09
I had mistake in the question - I have values() – Annabelle Jun 11 '19 at 10:11
1

Okay, it should work. If it doesn't, you are supposed to provide an MCVE as a proof. – Your Common Sense Jun 11 '19 at 10:12
Thank you, I had a mistake in the table structure. Thanks to your information that the code is OK, I searched in another places for the solution – Annabelle Jun 11 '19 at 10:19

MySQL PHP Insert Update on duplicate key with varchar value

0 Answers0