1. Jadval yaratish

MySQL tilida amallar bajarish


1. Jadval yaratish:

create table name_table(id integer primary key auto_increment,

username varchar(size),
pass varchar(size));


2. Yaratilgan jadvalga ma`lumot qo`shish


insert into name_table(username,password) values(“Salom“,“123“);
3. Yaratilgan jadvaldan ma`lumot o`chirish

delete from users where id=1

4. Barcha ustunlarni tanlab ko`rsatish


select * from name_table


5. Javdvalda kiritilgan ma`lumotlar sonini chiqarish


SELECT count(id) FROM phplessons.users;


6. Javdvalda kiritilgan int turdagi ma`lumotlar yig`indisini chiqarish
SELECT sum(id) FROM phplessons.users;


7. Javdvalda kiritilgan ma`lumotlarni ID orqali intervaldagi ma`lumotlarni chiqarish


SELECT * FROM users where id between 2 and 6;


8. Javdvalda kiritilgan ma`lumotlarni ustun bo`yicha saralab chiqarish


SELECT * FROM users order by username


9. Javdvalda kiritilgan ma`lumotlarni ustun bo`yicha saralash va teskari tartibda saralb chiqarish


SELECT * FROM users order by username ASC tog`ri tartibda


SELECT * FROM users order by username DESC teskari tartibda
10. Javdvalga yangi ustun qo`shish


alter table users add ustun_nomi varchar(50)


11. Javdvaldagi ixtiyoriy ustunning ma`lumot tipini o`zgartirish


alter table users modify column ustun_nomi int(20)
12. Jadvaldagi ixtiyoriy ustunni o`chirib tashlash


alter table users drop ustun_nomi
13. Jadvallarni bir-biri bilan bog`lash


SELECT * FROM guruhlar as g left join oquvchilar as o on
g.id = o.Guruh_id