Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
sale
1
möp
busID
Cuba
ventas
Employee
daily score
Umang Khambhalikar
Finde einmalige Datensätze im Vergleich mehrerer Tabellen
Please log in to post a comment.