Yangi jadval yaratish
CREATE TABLE yangi (
tartib INT not null,
FISH VARCHAR (100) NOT NULL,
Yoshi INT NOT NULL,
primary key (tartib)
);
Yangi yozuv qo'shish
INSERT INTO Talaba ( id_talaba, Familiya, Ism, Sharifi)
VALUES (5, 'Aliyev', 'Vali', 'Boliyevich');
Yozuvni o'zgartirish
UPDATE Talaba SET Familiya = 'Qodirov'
WHERE id_talaba=1;
Yozuvni o'chirish
DELETE *
FROM Talaba
WHERE id_talaba=0;
Do'stlaringiz bilan baham: |