Create table turon id bigserial primary key


Download 13.79 Kb.
Sana25.12.2022
Hajmi13.79 Kb.
#1065352
Bog'liq
SQL kodlar


CREATE TABLE turon(
id BIGSERIAL PRIMARY KEY,
fudbolchi_ismi varchar (20) NOT NULL,
fudbolchi_familiyasi varchar (20) NOT NULL,
fudbolchi_sharifi varchar (20) NOT NULL,
olgan_mukofotlari varchar (20) NOT NULL,
oldingi_kulubi varchar (20) NOT NULL,
malumoti varchar (20) NOT NULL,
tugulgan_davlati varchar (20) NOT NULL,
tugulgan_sanasi DATE NOT NULL,
yillik_maoshi NUMERIC NOT NULL,
urgan_gollari NUMERIC NOT NULL,
kulubdagi_raqami NUMERIC NOT NULL);

INSERT INTO turon( fudbolchi_ismi, fudbolchi_familiyasi, fudbolchi_sharifi, olgan_mukofotlari, oldingi_kulubi, malumoti, tugulgan_davlati, tugulgan_sanasi, yillik_maoshi, urgan_gollari ,kulubdagi_raqami)


VALUES (‘Asliddin’, ‘ Almardonov’, ‘ Faxridinovich’, ‘Jaxon_kubogi’, ‘Surxon’, ‘Urta_proffisonal’, ‘Uzbekistan’, date ‘2002-10-28’, numeric ‘7600006000’, numeric ‘97’, numeric ‘1’);
Download 13.79 Kb.

Do'stlaringiz bilan baham:




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