Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE osoba(id INT, nazwisko CHAR(20), imie CHAR(20));
- CREATE TABLE osoba1(id INT, nazwisko CHAR(20), imie CHAR(20), PRIMARY KEY (id));
- ALTER TABLE klasa ADD PRIMARY KEY(id);
- CREATE TABLE osoba2(id INT, nazwisko CHAR(20), imie CHAR(20), kl INT, FOREIGN KEY(kl) REFERENCES klasa(id));
- CREATE TABLE osoba3(id INT, nazwisko CHAR(20), imie CHAR(20) NOT NULL);
- CREATE TABLE osoba4 (id INT UNIQUE, nazwisko CHAR(20), imie CHAR(20) NOT NULL);
- CREATE TABLE osoba5 (id INT UNIQUE, nazwisko CHAR(20) DEFAULT "Kowalsi", imie CHAR(20) NOT NULL);
- CREATE TABLE osoba6(id INT UNIQUE AUTO_INCREMENT, nazwisko CHAR(20) DEFAULT "Kowalsi", imie CHAR(20) NOT NULL);
- ALTER TABLE osoba6 RENAME TO osoba;
- DROP TABLE osoba5;
- ALTER TABLE osoba ADD COLUMN wiek INT;
- ALTER TABLE osoba ADD COLUMN pesel INT FIRST;
- ALTER TABLE osoba DROP COLUMN id;
- ALTER TABLE osoba ADD PRIMARY KEY(pesel);
- ALTER TABLE osoba ADD COLUMN miasto CHAR(20) AFTER imie;
- ALTER TABLE osoba CHANGE COLUMN imie pseudonim CHAR(20);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement