Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop database cringe;
- create database cringe;
- use cringe;
- CREATE TABLE Marka (
- id_m int NOT NULL AUTO_INCREMENT,
- nazwa VARCHAR(30) NOT NULL,
- PRIMARY KEY (id_m)
- );
- CREATE TABLE Silnik (
- id_s int not null auto_increment,
- typ varchar(20),
- moc int,
- pojemnosc float,
- PRIMARY KEY (id_s)
- );
- CREATE TABLE Samochod (
- id_s int NOT NULL AUTO_INCREMENT,
- id_m int NOT NULL,
- rok_p DATE NOT NULL,
- PRIMARY KEY (id_s),
- FOREIGN KEY (id_m) REFERENCES Marka (id_m)
- );
- -- Inserting sample data into Marka table
- INSERT INTO Marka (nazwa) VALUES
- ('Toyota'),
- ('Ford'),
- ('Chevrolet');
- -- Inserting sample data into Silnik table
- INSERT INTO Silnik (typ, moc, pojemnosc) VALUES
- ('Diesel', 150, 2.0),
- ('Petrol', 120, 1.8),
- ('Electric', 200, 0.0);
- -- Inserting sample data into Samochod table
- INSERT INTO Samochod (id_m, rok_p) VALUES
- (1, '2022-01-01'),
- (2, '2023-02-15'),
- (3, '2021-05-10');
- CREATE PROCEDURE jeden(
- IN marka_in VARCHAR(30),
- IN pojemnosc_in FLOAT
- )
- SELECT *
- FROM Samochod
- JOIN Marka ON Samochod.id_m = Marka.id_m
- JOIN Silnik ON Samochod.id_s = Silnik.id_s
- WHERE Marka.nazwa = marka_in AND Silnik.pojemnosc = pojemnosc_in;
- CALL jeden('Toyota', 2.0);
- CREATE PROCEDURE dwa(
- IN limitMocy_in INT,
- OUT liczba_aut INT
- )
- SELECT COUNT(*)
- INTO liczba_aut
- FROM Samochod
- JOIN Silnik ON Samochod.id_s = Silnik.id_s
- WHERE Silnik.moc > limitMocy_in;
- SET @liczba_aut = 0;
- CALL dwa(150, @liczba_aut);
- SELECT @liczba_aut;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement