SQL ntaub ntawv. SQL ntaub ntawv hom extension hauj lwm

Databases - ib tug complex system, uas muaj ntaub ntawv nyob rau hauv lub txuas ntxhuav. SQL ntaub ntawv - SQL cov hom ntawv uas cov ntaub ntawv nyob rau hauv lub databases. Nyob rau hauv lwm yam lus, nws yog ib tug dawb ntawv nyeem ntaub ntawv nrog ib tug txheej ntawm cov lus qhia kev ua hauj lwm uas muaj ntaub ntawv nyob rau hauv lub rooj.

piav qhia

* .sql cov hom ntaub ntawv stands "ntxwv cov ntaub ntawv cov lus nug hom lus" (structured cov ntaub ntawv yog cov lus nug hom lus). Categorically hais txog cov database ntaub ntawv. Nws muaj ntawv nyeem cov lus qhia, raws li zoo raws li ib tug txheej ntawm cov lus qhia uas tso cai rau nws los mus daws - mus nrhiav, cais, rho tawm kab los ntawm ib tug DB (database), ntxiv tshiab sawv daws yuav, tsim kuaj raws li kev cai tswjhwm tsis. qhia set yog nyob rau hauv daim ntawv ntawm cov lus nug lus nqe lus.

Lub qhib SQL tej ntaub ntawv?

SQL neeg rau hom ntawv qhib tag nrho cov kev pab cuam uas ua hauj lwm nrog databases. Qhov no daim ntawv teev muaj xws li:

• MySQL - ib qho ntawm feem ntau DBMS (database system tswj). Tau tshaj tag nrho cov loj khiav hauj lwm systems.
• Microsoft Office Access - ib qho kev pab los ntawm lub txhab txheej chaw ua hauj lwm software rau lub qhov rais.
• PostgreSQL - ib tug niaj hnub thiab yooj yim database competes nrog MySQL.

Tag nrho cov ntawm cov kev pab cuam (tsuas yog hais tias Access) tsis tau tsuas yog tsim nyob rau hauv, tab sis kuj ua kev kho me ntsis rau lub system cov ntaub ntawv thaum lub sij hawm lub installation - teem multifunctional database yog ib qhov nyuaj thiab ua tau tsuas yog thaum qhov yuav tsum tau rau ntxiv ua hauj lwm. Txwv tsis pub xav txog lwm yam embodiments.

ntawv nyeem editors

Nyob rau hauv thiaj li yuav pom zoo li cas cov ntaub ntawv muaj SQL, * .sql yuav qhib siv tej yam yooj yim ntawv nyeem editor xws li "Notepad", Wordpad, Notepad los yog Vim. Nyob rau hauv tas li ntawd, lub chaw "tej yam" txhais tau tias ntawv nyeem editors "Linux" no kuj tau qhib thiab hloov database ntaub ntawv.

Tseem Ceeb! Tom qab editing cov ntaub ntawv, yuav tsum txhob cia nws nyob rau hauv nws cov thawj hom ntawv.

Lub disadvantage ntawm no txoj kev: cov tsis muaj functionality ntawm cov database. Muaj ua hauj lwm nrog cov ntawv nyeem cov ntsiab lus, tsis tau ib tug system ntawm ceeb toom ntawm qhov yuam kev los sau ib cov lus nug, los yog ib tug Underscore typos thaum cov ntaub ntawv hloov. Vim li no, rau editing SQL ntaub ntawv, SQL databases yog zoo suited.