Comments - User-Defined Variables
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
SELECT @var:=<expression> FROM...
are executed, @var will always correspond to the value in the last row returned, as you might expect.
i think the sql is exactly the same as mySQL because in mySQL it generates different values according to the row
whereas in mariaDB all rows are filled in with the same value in the last row
so, what is the best solution? anyone can explain it