Increment a database field by 1

Updating an entry: A simple increment should do the trick. UPDATE mytable SET logins = logins + 1 WHERE id = 12 Insert new row, or Update if already present: If you would like to update a previously existing row, or insert it if it doesn’t already exist, you can use the REPLACE syntax or … Read more