MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table Transactions (code varchar(10), qty int, date datetime primary key);
insert into Transactions values('123', 100, '2018-01-01 00:00:00');
insert into Transactions values('123', 100, '20180102');
insert into Transactions values('123', 100, '20180103');
insert into Transactions values('123', 100, '20180104');
insert into Transactions values('123', 100, '20180105');
SELECT date,
       qty, 
       @acm := @acm + qty as stock
FROM
    Transactions t,
    (SELECT @acm := 0) x


date
qty
stock


2018-01-01 00:00:00
100
100

2018-01-02 00:00:00
100
200

2018-01-03 00:00:00
100
300

2018-01-04 00:00:00
100
400

2018-01-05 00:00:00
100
500


ALTER TABLE Transactions t
ADD @acm := @acm + qty as stock
(SELECT @acm := 0) x
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD @acm := @acm + qty as stock
(SELECT @acm := 0) x' at line 2

SELECT * FROM Transactions


code
qty
date


123
100
2018-01-01 00:00:00

123
100
2018-01-02 00:00:00

123
100
2018-01-03 00:00:00

123
100
2018-01-04 00:00:00

123
100
2018-01-05 00:00:00


CREATE VIEW transactions
AS (SELECT date, qty, @acm := @acm + qty AS stock
FROM
    Transactions t,
    (SELECT @acm := 0) x)
View's SELECT contains a variable or parameter

SELECT * FROM transactions
Table 'fiddle_LFQAIJCUCJHYQSLOWOZC.transactions' doesn't exist

date	qty	stock
2018-01-01 00:00:00	100	100
2018-01-02 00:00:00	100	200
2018-01-03 00:00:00	100	300
2018-01-04 00:00:00	100	400
2018-01-05 00:00:00	100	500