- Add
BEGIN
INSERT INTO zanr(zanrNimi, zanrKirjeldus)
VALUES(
zanrNimi, zanrKirjeldus);
SELECT * FROM zanr;
END
Work-Check
2. Kustutamine
BEGIN
SELECT * FROM zanr;
DELETE FROM zanr WHERE zanrID=id;
SELECT * FROM zanr;
END
3. Drop-table
BEGIN
SET
@STMT = CONCAT(“DROP TABLE “, tabeli_nimi);
PREPARE S FROM @STMT;
EXECUTE S;
DEALLOCATE PREPARE S;
END
Work-Check
