8-mavzu. Python va MySQLda ma’lumot kiritish va tahrirlash

Mysql da kiritish operatorini kiriting (kichik harflarda).

MySQl da kiritish operatorini belgilang?

• delete

• insert into

• select

• update

MySQl da tahrirlash operatorini belgilang?

• delete

• insert into

• select

• update

MySQl da tanlash operatorini belgilang?

• delete

• insert into

• select

• update

Nuqtalar o'rniga mos kalit so'zni kiriting (kichik harflarda).

INSERT ... foydalanuvchilar

VALUES ('John', 30);

Nuqtalar o'rniga mos kalit so'zni kiriting (kichik harflarda).

insert into values(ismi, yoshi, kursi) talaba ... ('john', 30, 4);

To'g'ri javoblarni belgilang?

• INSERT INTO foydalanuvchilar (ism, yosh)

  VALUES ('John', 30);

• INSERT INTO foydalanuvchilar

  VALUES ('John', 30);

• INSERT foydalanuvchilar

  VALUES ('John', 30);

• INSERT INTO foydalanuvchilar

  ('John', 30);

Nuqtalar o'rniga mos kalit so'zlarni kiriting(kichik harflarda).

update talaba ... ismi='Akmal' where age=18;

Nuqtalar o'rniga mos kalit so'zlarni kiriting(kichik harflarda).

... talaba set ismi='Nodir' where course=4;

Nuqtalar o'rniga mos kalit so'zlarni kiriting(kichik harflarda).

update talaba set ismi='Nodir' ... course=4;