request.sql 481 Bytes
Newer Older
VisentiniEmilien's avatar
VisentiniEmilien committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
SELECT name
from game
where name LIKE '%Mario%' OR alias LIKE '%Mario%';


SELECT name
from company
where location_country LIKE '%Japan%';


SELECT name
from platform
where install_base > 10000000;

SELECT name
from game
order by name
limit 21173, 442;


drop procedure if exists page;

delimiter //
CREATE PROCEDURE page (IN p INT)
BEGIN
    set p = (p-1)*500;
    SELECT id, name
    from game
    order by id
    limit p, 500;
END//

Safyrus's avatar
Safyrus committed
33
call page(2)