Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE IF NOT EXISTS dbtemp;
- CREATE TABLE studenci (
- id_studenta INT NOT NULL,
- imie VARCHAR(25) NULL,
- nazwisko VARCHAR(25) NULL,
- numer_indeksu INT NOT NULL,
- );
- INSERT INTO studenci (id_studenta, imie, nazwisko, numer_indeksu)
- VALUES
- (1, 'Adam', 'Nowak', 32301),
- (2, 'Janusz', 'Kowalski', 32302),
- (3, 'Piotr', 'Potocki', 32303),
- (4, 'Krzysztof', 'Krawczyk', 32304);
- ALTER TABLE studenci
- ADD PRIMARY KEY (id_studenta);
- ALTER TABLE studenci
- ADD UNIQUE KEY (numer_indeksu);
- ALTER TABLE studenci
- MODIFY COLUMN id_studenta INT AUTO_INCREMENT;
- DROP TABLE studenci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement