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
air_flight
mysql - insert
grre
My name is busy
dhin
Creation tables
Test
mywall
name
Get max score and the fields in the max score row in MySQL 5.7