MySQL: What does equal colon = = mean in an update expression?

Question

MySQL: What does equal colon = = mean in an update expression?

I came across the following MySQL query:

update 'table' set itemId=:itemId, startDate=:startDate where id=:id

However, I could not understand what the meaning of :: means. I think the name after =: is a variable, but then how to check what's inside or how is it set?

+5

variables mysql

Ruben May 01 '12 at 5:37

source share

1 answer

Patrick moore · Accepted Answer · 2012-05-01T05:43:08+0000

Most likely a link to a bind variable. PHP or other code that executes the MySQL statement replaces the reference variable.

MySQL: What does equal colon = = mean in an update expression?

More articles: