Bozor nomli ma’lumotlar bazamizga customer nomli jadval yatatib olamiz: create table

3. Demak avval bozor nomli ma’lumotlar bazamizga customer nomli jadval yatatib olamiz:
CREATE TABLE customer (id INTEGER PRIMARY KEY AUTO_INCREMENT,

CustomerName VARCHAR(30), TelephoneNumber VARCHAR(15));

Endi esa uni ma’lumotlat bilan to’ldiramiz:

INSERT INTO customer (CustomerName, TelephoneNumber) VALUES ('Doston Urunov' , '[phone]');

INSERT INTO customer (CustomerName, TelephoneNumber) VALUES ('Abbosbek Ibragimov' , '[phone]');

INSERT INTO customer (CustomerName, TelephoneNumber) VALUES ('Shoxruz Yunusov' , '[phone]');

INSERT INTO customer (CustomerName, TelephoneNumber) VALUES ('Halima Vahobova' , '[phone]');

INSERT INTO customer (CustomerName, TelephoneNumber) VALUES ('Akmal Holiqov' , '[phone]');

Demak biz bozor ma’lumotlar bazasida customer nomli jadval yaratib oldik. Endi esa bemalol yuqorida berilgan so’rovimizni amalga oshirsak bo’ladi:

WHERE customerName LIKE '%a'
va u bizga CustomerName ya’ni mijozlarning ismining oxirida “a” harfi bor yoki yo’qligini tekshiradi.

Biz bunga amin bo’lish uchun quyidagicha so’rov yuboramiz. Bunda biz so’rov yuborganimizda customer jadvalidagi mijozlarning CustomerName ya’ni ismining oxirida “a” harfi mavjud bo’lsa, bizga bu mijoz haqidagi barcha ma’lumotlarni chiqarsin:

SELECT * FROM customer WHERE customerName LIKE '%a'