1. Malumotlar bazasi tushunchasi


INSERT INTO table_name (column1, column2, column3, ...)


Download 132.35 Kb.
bet17/17
Sana16.02.2023
Hajmi132.35 Kb.
#1203121
1   ...   9   10   11   12   13   14   15   16   17
Bog'liq
Berilganlar bazasi Arginal (2)

INSERT INTO table_name (column1, column2, column3, ...)

VALUES (value1, value2, value3, ...);


INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)

VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway')


26 .
SQL tilida maydon tushunchasi



29.
SQL tilida jadval tuzing


MySQL CREATE TABLE bayonoti

Ushbu CREATE TABLEbayonot ma'lumotlar bazasida yangi jadval yaratish uchun ishlatiladi.


Sintaksis
CREATE TABLE table_name
( Column 1 datatype,column 2 datatype, column3 datatype,
....);
Misol:
CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);

25 .
SQL tilida jadvalning loyihasini tuzing



27
SQL muhitida bir nechta jadvallardan ma’lumotlar olish deganda nimani tushunasiz



41.
Tranzaksiyalarning bajarilish jarayonida ma’lumotlarning himoyalanish darajasi deganda nimani tushunasiz



37.
So’rov nima va u nima uchun ishlatiladi



11. SQL tilida jadval yozuvlarini o’zgartirish




Download 132.35 Kb.

Do'stlaringiz bilan baham:
1   ...   9   10   11   12   13   14   15   16   17




Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling