I am trying to apply pagination with limit and offset in MYSQL but its not working can somebody help

See more:

MySQL

DBMS

I have made customer table no problem in that.
mysql> SET @pageno = 2;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from customer limit 2 offset (limit)*(@pageno-1);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(limit)*(@pageno-1)' at line 1

What I have tried:

mysql> SET @pageno = 2;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from customer limit 2 offset (limit)*(@pageno-1);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(limit)*(@pageno-1)' at line 1