Increment a database field by 1

With MySQL, if I have a field, of say logins, how would I go about updating that field by 1 within a sql command?

I’m trying to create an INSERT query, that creates firstName, lastName and logins. However if the combination of firstName and lastName already exists, increment the logins by 1.

so the table might look like this..


John               Jones             1
Steve              Smith             3

I’m after a command that when run, would either insert a new person (i.e. Tom Rogers) or increment logins if John Jones was the name used..

Best Answer

Leave a Comment