Create table (table nomi) (id int(11) auto increment primary key, (satr1) varchar(20),

Table yaratish:
Create table (table nomi) (id int(11) auto_increment primary key, (satr1) varchar(20), (satr2) int(3)……);

Yangi ustun qo’shish:

Alter table (table nomi) add (qo’shiladigan ustun nomi) int(4);
Birilgan satrni o’zgartirish update:
Update (table nomi) set (ustun nomi)=”o’zgartirish kerak bulgan nom” where id=(kerakli id);
Satr kritish.
Insert into (`table nomi`) ((`satr1`),(`satr2`)……) values(“nom1”,”nom2”….);
Tanlab olish. Satrni boshharfi “b” bulgan suzlarni chiqarib beradi:
Select *from (table nomi ) where (qidiralayotgan ustun nomi) like “b%”;