Hi,
Please Update my MySQL database to version 8 or the latest.
I want to use the Row_Number function inside select Statement. and other partition commands.
Thanks much
Hi,
Please Update my MySQL database to version 8 or the latest.
I want to use the Row_Number function inside select Statement. and other partition commands.
Thanks much
We do no have MySQL 8 database servers available.
Okey so only in version 8 that ROW_NUMBER() built in function works. Do you know how the code below work in older version. I tried this table bash and it works. but when I tried in python py file it get error in the SET statement. see below code. Thanks.
SET @row_number = 0;
SELECT
(@row_number:=@row_number + 1) AS num,
id,
FullName
FROM
Voters
ORDER BY id
LIMIT 5;