Ifayile SQL. ifayile SQL incazelo ifomati ulwandiso

Sogcino - kwinkqubo, eziqulathe ulwazi kwiitheyibhile ezinxulumene. ifayile SQL - ifomathi SQL i data kwi zolwazi. Ngamanye amazwi, le fayile okubhaliweyo okungenanto neqela imiyalelo yokusebenza data kwi tafile.

incazelo

* Ifomati yefayile .sql imela "Structural data ulwimi umbuzo" (iifayile structured lulwimi nombuzo). Ngokucacile ibhekisa iifayile ledatha. Iqulethe ulwazi itekisi, kwakunye imiyalelo evumela ukuphatha - ukukhangela, hlela, ukucima imiqolo ukusuka DB (database), yongeza ezintsha, ukudala iisampulu ezisekelwe kwi parameters ezichaziweyo. isethi imfundo inikwa ngohlobo lwezitetimenti zombuzo ulwimi.

Ifayile SQL evulekileyo?

format SQL ivula zonke iinkqubo ezisebenza zolwazi. Olu luhlu luquka:

• I SQL yam - enye ixhaphakileyo DBMS (inkqubo yolawulo database). Ihambelana zonke iinkqubo ezinkulu yokusebenza.
• Microsoft Office Access - inkqubo kwisethi eyandisiweyo software ofisi for Windows.
• PostgreSQL - uvimba mihla lula icompetition I SQL.

Zonke ezi nkqubo (ngaphandle Access) nje kuphela yasekwa, kodwa ukwenza utshintsho iifayile ngexesha lofakelo i - ukuseta ledatha nemiba ngemiba kunzima kunye nokwenzeka kuphela xa imfuneko yomsebenzi engaphezulu. Kungenjalo cinga ezinye embodiments.

abahleli umbhalo

Ukuze ubone ukuba ifayile iqulethe SQL, * .sql iya kuvulwa ngokusebenzisa nayiphi umhleli wokubhaliweyo elula efana "Notepad", Wordpad, Iphetshan lokubhala okanye vím. Ukongeza, i Isichazi "na" kuthetha ukuba abahleli umbhalo "Linux" unako ukuvula kunye hlela iifayile ledatha.

Okubalulekileyo! Emva uhlela ifayile, qiniseka ukuba siyigcine format yayo yoqobo.

Engxakini kule ndlela: ukungabikho ukusebenza ledatha. Kufuneka basebenze kuphela umxholo umbhalo, ngaphandle kungenzeka inkqubo isaziso impazamo ukubhala umbuzo, okanye okubhala zibeka xa utshintsho data. Ngenxa yesi sizathu, lokuhlela iifayile SQL, edatha SQL ezifaneleke ngakumbi.