Increment a database field by 1

Name: Redmi Y2 Tech Review
Uploaded: 2018-08-05 T20:00:00+05:30
Duration: 6 min 59 s
Description: Namasty dosto is video maine Xiaom Redmi Y2 bare mein baat krunga, or sath hi Redmi Y2 ke kuch key features aapke sath share krunga. 1. Dual 12MP + 5MP cameras width Precise bokeh effect. 2. 16MP front camera width 4500K soft-toned light.

With MySQL, how would I updating table field by 1 within a sql command?

Ankur Rajput

Asked 17-12-2024

192

Answer (1)

UPDATE mytable 
  SET logins = logins + 1 
  WHERE id = 12

Deepak Sharma

Asked 18-07-2018

45 Likes

Comments

Write comment

Submit your answer