· 8 years ago · Apr 22, 2018, 10:32 AM
1CREATE DATABASE IF NOT EXISTS dbtemp;
2
3CREATE TABLE studenci (
4 id_studenta INT NOT NULL,
5 imie VARCHAR(25) NULL,
6 nazwisko VARCHAR(25) NULL,
7 numer_indeksu INT NOT NULL,
8);
9
10INSERT INTO studenci (id_studenta, imie, nazwisko, numer_indeksu)
11VALUES
12(1, 'Adam', 'Nowak', 32301),
13(2, 'Janusz', 'Kowalski', 32302),
14(3, 'Piotr', 'Potocki', 32303),
15(4, 'Krzysztof', 'Krawczyk', 32304);
16
17ALTER TABLE studenci
18ADD PRIMARY KEY (id_studenta);
19
20ALTER TABLE studenci
21ADD UNIQUE KEY (numer_indeksu);
22
23ALTER TABLE studenci
24MODIFY COLUMN id_studenta INT AUTO_INCREMENT;
25
26DROP TABLE studenci;