Interogari Magazin

Baza de date Magazin

Clienti

Produse

Cos

SELECT `Nume` FROM `clienti`, cos WHERE clienti.IdClient=cos.IdClient;

UPDATE `clienti` SET `NrCreditCard`='21314567' WHERE IdClient=1;

1. Calculati valoarea stocului pentru Banane.

SELECT `IdProdus`, `Categorie`, `Descriere`, `PretUnitar`* `Stoc` as Valoare FROM `produse` WHERE descriere='Banane'

1

http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fselect.html&server=0&token=9f55f306f7411604337057d2a1bde17e

http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fselect.html&server=0&token=b0f954a1a9b42e8a8ea7b63d5a495efb

2. Care este IDClient care a cumparat Mazare?

Select IdClient From cos where cos.IdProdus=(Select produse.IdProdus From produse where descriere='Mazare');

3. Cum se numeste clientul care a cumparat Mazare?

Select Nume, Prenume From clienti Where clienti.IdClient=(Select IdClient From cos where cos.IdProdus=(Select produse.IdProdus From produse where descriere='Mazare'))

4. Ce produse a cumparat clientul Danila Emil?

SELECT `Nume`, `Prenume`, descriere FROM `clienti`,cos, produse WHERE nume='Danila'and prenume='Emil'and clienti.IdClient=cos.IdClient and cos.IdProdus=produse.IdProdus

2

http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Flogical-operators.html&server=0&token=6e5e566b11f3fd531f699747995dc910#operator_and



http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fselect.html&server=0&token=6e5e566b11f3fd531f699747995dc910




1. Cum se numesc clientii care au cumparat Dulciuri?

Select Nume, Prenume From clienti Where clienti.IdClient=(Select IdClient From cos where cos.IdProdus=(Select produse.IdProdus From produse where categorie='Dulciuri'));

2. ..

3




Interogari Magazin

Documents

Transcript of Interogari Magazin