Change the value to be greater than the previous one by 1?

N

N

Name2018-01-28 08:09:20

SQL

Name, 2018-01-28 08:09:20

Change the value to be greater than the previous one by 1?

Hello. Help solve the issue.
The following records exist in the table table:
date
_____________________
2018-01-01 00-00-00
2018-01-01 00-00-00
2018-01-01 00-00-00
2018-01-01 00-00-00
2018 -01-01 00-00-00
...
2018-01-01 00-00-00
what SQL query can add a second to each record more than in the previous
one, that is, it should turn out like this
2018-01-01 00-00 -01
2018-01-01 00-00-02
2018-01-01 00-00-03
2018-01-01 00-00-04
2018-01-01 00-00-05
...
2018-01-01 01-00-00

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

S

Sanzhar Bazarbek2021-04-04 12:35:40

How to remove blur from an image? 2Reply

D

deathault2017-08-17 12:00:25

Is there a console browser for Android Studio? 2Reply

N

newaitix2017-09-14 23:01:29

Why does my phone screen turn on? 2Reply

K

Kirill Bazhenov2017-10-05 10:58:47

The math module does not work, Python 3.6.3 on 3.6.2 also did not work with the PyCharm IDE, what should I do? 1Reply

O

Outsider V.2017-11-13 21:11:25

How to submit avatar along with registration form via AJAX? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question