create DATABASE Towary2
Expand Wykonaj zapytanie ponownie Edytuj Dodaj do zakładek Baza danych:  Czas zapytania: 10:55:26
CREATE TABLE klienci ( id_klienta int AUTO_INCREMENT NOT NULL PRIMARY KEY, nazwa varchar(20) NOT NULL, kod varchar(6) NOT NULL, miasto varchar(20) NOT NULL, ulica varchar(20) NOT NULL, nip varchar(13) NOT NULL, telefon varchar(9) NOT NULL, mail varchar(20) NOT NULL)
SELECT * FROM `klienci`
insert into klienci (nazwa, kod, miasto, ulica, nip, telefon, mail) values ("BUDIMEX", 62-302, "Bagno","Bagienna", 12345678901, 693421499,"sdsw@o2.pl")
SELECT * FROM `klienci`
UPDATE `towary2`.`klienci` SET `kod` = '62240' WHERE `klienci`.`id_klienta` = 1;
insert into klienci (nazwa, kod, miasto, ulica, nip, telefon, mail) values ("CEMENTEX", 63234, "Fajne","Fajna", 12345678923, 693422399,"sdsdasw@o2.pl")
insert into klienci (nazwa, kod, miasto, ulica, nip, telefon, mail) values ("KELMEX", "62-590", "Konin","Kazimierska", 12345678231, 693423499,"wqeqw@o2.pl")
insert into klienci (nazwa, kod, miasto, ulica, nip, telefon, mail) values ("PIOTREX", "62-302", "Kramsk","Konińska", 1234567890, 694311499,"wwwww@o2.pl")
SELECT * FROM `klienci`
insert into klienci (nazwa, kod, miasto, ulica, nip, telefon, mail) values ("KURZAWEX", "62-232", "Kelma","Adama", 1234347890, 114311499,"qcwww@o2.pl")
update klienci set nazwa="KONPEX" where nazwa="CEMENTEX"
SELECT * FROM `klienci`
UPDATE `towary2`.`klienci` SET `kod` = '63-234' WHERE `klienci`.`id_klienta` = 2;
UPDATE `towary2`.`klienci` SET `kod` = '62-240' WHERE `klienci`.`id_klienta` = 1;
UPDATE `towary2`.`klienci` SET `nip` = '1234567823' WHERE `klienci`.`id_klienta` = 3;
UPDATE `towary2`.`klienci` SET `nip` = '1234568923' WHERE `klienci`.`id_klienta` = 2;
UPDATE `towary2`.`klienci` SET `nip` = '1245678901' WHERE `klienci`.`id_klienta` = 1;
update klienci set miasto="Konin",ulica="Kolejowa 10" where nazwa="KONPEX"
SELECT * FROM `klienci`
CREATE TABLE dzieci ( id_towaru int AUTO_INCREMENT NOT NULL PRIMARY KEY, nazwa varchar(20) NOT NULL, cena decimal(7,2) NOT NULL , jm ENUM("kg","szt","l") NOT NULL, proc_vat decimal(5,2))
SELECT * FROM `klienci`
SELECT * FROM `klienci`
SELECT * FROM `dzieci`
alter table dzieci rename towary
SELECT * FROM `towary`
INSERT into towary (nazwa, cena, jm, proc_vat) VALUES ("cement", 25, "kg", 0.23)
INSERT into towary (nazwa, cena, jm, proc_vat) VALUES ("drabina", 100, "szt", 0.23)
INSERT into towary (nazwa, cena, jm, proc_vat) VALUES ("benzyna", 4.67, "l", 0.23)
INSERT into towary (nazwa, cena, jm, proc_vat) VALUES ("cegły", 2, "szt", 0.23)
INSERT into towary (nazwa, cena, jm, proc_vat) VALUES ("betoniarka", 2500, "szt", 0.23)
INSERT into towary (nazwa, cena, jm, proc_vat) VALUES ("smar", 15, "szt", 0.23)
SELECT * FROM `towary`
ALTER table towary ADD Data_wazn date
SELECT * FROM `towary`
UPDATE `towary2`.`towary` SET `nazwa` = 'cegly' WHERE `towary`.`id_towaru` = 4;
update towary set Data_wazn="25.02.2017" where nazwa="cement"
update towary set Data_wazn="25.02.2050" where nazwa="drabina"
update towary set Data_wazn="25.02.2025" where nazwa="benzyna"
update towary set Data_wazn="25.02.2020" where nazwa="cegly"
update towary set Data_wazn="25.02.2018" where nazwa="betoniarka"
update towary set Data_wazn="25.02.2017" where nazwa="smar"
SELECT * FROM `klienci`
SELECT * FROM `klienci` WHERE miasto="Konin"
SELECT * FROM klienci WHERE nazwa like "K%"
SELECT nazwa, mail FROM klienci order by nazwa DESC
Select * from klienci where nazwa="_o%"
Select * from klienci where nazwa like "_o%"
SELECT nazwa, miasto FROM `klienci` WHERE telefon like "%23%"
SELECT * FROM `klienci` WHERE id_klienta = "1,3,5"
SELECT * FROM `klienci` WHERE id_klienta = "1,3,5"
SELECT * FROM `klienci` WHERE id_klienta = "1" and "3" and "5"
SELECT * FROM `klienci` WHERE id_klienta = "1" and "3" and "5"
SELECT * FROM `klienci` WHERE id_klienta = 1 or id_klienta = 3 or id_klienta = 5
SELECT * FROM `klienci` WHERE miasto="Konin" or miasto="Turek" and nazwa like "K%"
SELECT DISTINCT miasto FROM klienci
SELECT * FROM `towary`
SELECT * FROM towary WHERE cena>10
SELECT * FROM towary WHERE cena between "5" and "10"
SELECT * FROM towary WHERE cena between 5 and 10
SELECT * from towary order by cena DESC limit 3
SELECT * from towary WHERE proc_vat="0.23"
SELECT nazwa,cena FROM towary order by 2
SELECT nazwa,cena*(1+proc_vat) as cena_brutto FROM `towary`
SELECT concat (nazwa,"kosztuje",cena) FROM `towary`
SELECT concat (nazwa," kosztuje ",cena) FROM `towary`
SELECT * FROM `klienci`
select count(*) from klienci where miasto="Konin"
SELECT * FROM `towary`
SELECT sum(cena) FROM towary
SELECT avg(cena) from towary
SELECT max(cena) from towary
SELECT min(cena) from towary
SELECT min(Data_wazn) from towary
SELECT * FROM `towary` order by Data_wazn ASC limit 1
SELECT * FROM `towary`
SELECT * FROM `klienci`
delete from klienci where miasto="Turek"
SELECT * FROM `towary`
alter table towary drop jm
SELECT * FROM `towary`