Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Running interval
Drop table if exists my_table; Create table my_table (id Int not null auto_increment primary key ,date_start Date not null ,added_days int not null); Insert into my_table values ( 1 ,'2017-10-10', 2), ( 2 ,'2017-10-10', 4), (3 ,'2017-10-10', 6), (4 ,'2017-10-10', 6), ( 5 ,'2017-10-10 ', 3); Select x.*, date_start+Interval @i day n, @i:=@i+added_days i from my_table x, (select @i:=0) vars order by id;
run
|
edit
|
history
|
help
0
https://ru.stackoverflow.com/questions/663810
exp11
school
Creation tables
vwall
test 2
delivery_history
Subrahmanyamk
mrgzmerch
saikatd