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
| 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
|
|
Do'stlaringiz bilan baham: |