KuTeUKSu

1create database school;
2use school;
3CREATE TABLE students
4(
5ID serial,
6Name varchar(20),
7Lastname varchar(20),
8score tinyint unsigned
9);
10
11insert into students values
12(null,"John", "Cena", 32),
13(null,"Obi", "Kenobi", 99),
14(null,"Post", "Malone", 61),
15(null,"Tupac", "Shakur", 42),
16(null,"Vardas", "Pavarde", 25);
17
18
19
20DELIMITER //
21CREATE PROCEDURE GetTable()
22BEGIN
23select name, lastname, score from students;
24END //
25DELIMITER ;
26
27
28delimiter //
29create procedure CreateTable()
30BEGIN
31CREATE TABLE IF NOT EXISTS students
32(
33ID serial,
34Name varchar(20),
35Lastname varchar(20),
36score tinyint unsigned
37);
38end //
39delimiter ;
40
41CREATE PROCEDURE MoreThan(IN num tinyint unsigned)
42
43
44
45
46CALL MoreThan(40);