· 7 years ago · Nov 28, 2018, 12:12 PM
1DROP TABLE IF EXISTS `Tabela`;
2CREATE TABLE Tabela(
3`id` int(10) unsigned NOT NULL,
4`imie` VARCHAR(100) NOT NULL,
5`nazwisko` VARCHAR(40) NOT NULL,
6`punkty` INT(11)
7)ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
8
9INSERT INTO `Tabela` (`id`, `imie`, `nazwisko`, `punkty`) VALUES (1,"Jan","Kowalski",143),(2,"Andrzej","Duda",143);
10
11CREATE USER 'admin'@'localhost' IDENTIFIED BY '1234';
12
13GRANT ALL PRIVILEGES ON Tabela TO admin;