Laboratoriya ishi-2 Mavzu: Ma’lumotlarni tanlash va ular ustida amallar Bajardi

Laboratoriya ishi-2

Mavzu: Ma’lumotlarni tanlash va ular ustida amallar

Bajardi: Normuminov Ibraxim

Guruh:13-19s

Qarshi-2021

AND, OR, NOT mantiqiy standart so‘zlardan foydalanish.

MySQL SELECT

SELECT select_list

FROM table_name;

MySQL da ma’lumotlarni tanlashda SELECT dan foydalanamiz.

SELECT lastName

FROM employees;

SELECT yordamida bir maydonlarni tanlash

SELECT

    lastname,

    firstname,

    jobtitle

FROM

    employees;

SELECT yordamida bir necha maydonlarni tanlash

SELECT *

FROM employees;

SELECT * yordamida barcha maydonlarni tanlash

MySQL AND Operator

mantiqiy_ifoda_1 AND mantiqiy_ifoda_2

AND operatori ko'pincha shartni shakllantirish uchun SELECT, UPDATE, DELETE operatorining WHERE bandida ishlatiladi.

AND operatori har ikki qiymatni tasdiqlashi shart.

SELECT

    customername,

    country,

    state

FROM

    customers

WHERE

    country = 'USA' AND state = 'CA';

SELECT    

    customername,

    country,

    state,

    creditlimit

FROM    

    customers

WHERE country = 'USA'

    AND state = 'CA'

    AND creditlimit > 100000;

MySQL OR Operator

mantiqiy_ifoda_1 OR mantiqiy_ifoda_2

OR operatori ko'pincha shartni shakllantirish uchun SELECT, UPDATE, DELETE operatorining WHERE bandida ishlatiladi.

OR operatorining AND operatoridan farqi birinchi yoki ikkinchi qiymatni tasdiqlash yetarli.

SELECT    

    customername,

    country

FROM    

    customers

WHERE country = 'USA' OR

      country = 'France';

SELECT  

    customername,

    country,

    creditLimit

FROM  

    customers

WHERE(country = 'USA'

        OR country = 'France')

      AND creditlimit > 100000;