Create table turon id bigserial primary key
Download 13.79 Kb.
|
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
ma'muriyatiga murojaat qiling