I'm wondering how to go about this:
I've a table in which I have a 'views' field. I would like to know whether there is a way to pass a command/func in SQL to MySQL that tells it to increment a specific field, say, where it's ID field = some value...ala:
Increment `views` + 1 WHERE 'id' = 123
Is this possible or do I have to code for this.
TIA
I've a table in which I have a 'views' field. I would like to know whether there is a way to pass a command/func in SQL to MySQL that tells it to increment a specific field, say, where it's ID field = some value...ala:
Increment `views` + 1 WHERE 'id' = 123
Is this possible or do I have to code for this.
TIA