DROP DATABASE IF EXISTS magazyn; CREATE DATABASE IF NOT EXISTS magazyn; USE magazyn; CREATE TABLE tab_magazyn ( id int PRIMARY KEY AUTO_INCREMENT, towar varchar(40), cena decimal(9,2), ilosc int, kod char(4) ); INSERT INTO tab_magazyn (towar, cena, ilosc, kod) VALUES ('ciastka','100','15','0001'), ('torty','150','25','0002'), ('wafle','50','10','0003'); GRANT ALL ON . TO 'uzytkownik'@'localhost' identified BY 'haslo123'; SELECT * FROM tab_magazyn;