SQL faira. SQL faira urongwa chiwedzerwa tsananguro

Databases - hwakaoma kunzwisisa, ane mashoko ari chokuita pamatafura. SQL faira - SQL nemanyorerwo humboo vari Databases. Mune mamwe manzwi, ndiye bani chinyorwa faira ane mamwe mirayiridzo kushanda mashoko pamahwandefa.

tsananguro

* .sql faira youduku rinomirira "Structural date mutauro mubvunzo" (muronga mafaira ndiwo mutauro mubvunzo). Categorically rinoreva Database mafaira. Rine chinyorwa ruzivo, uyewo chine mirayiridzo inobvumira kuti kubata - kunzvera, patsanura, zvinomuomera kuikanganwa mitsara kubva db (Database), wedzera vatsva, nokusika ivhu yakavakirwa wainyatsotaura parameters. kurairira yakatarwa anoratidzwa muchimiro mubvunzo mutauro mashoko.

The rakavhurika SQL faira?

SQL nemanyorerwo anovhura zvose zvirongwa anoshanda Databases. Pamazita Izvi zvinosanganisira:

• MySQL - chimwe chezvinhu zvakafanana DBMS (Database kutarisirwa hurongwa). Kunoenderana zvose zvinozivikanwa uchishandisa hurongwa.
• Microsoft Office Access - chirongwa kubva rakawedzerwa seti mahofisi Software nokuda Windows.
• PostgreSQL - rechimanjemanje uye zvakakunakira Database achikwikwidza pamwe MySQL.

Vose mapurogiramu aya (kunze kuti Access) kwete chete dzakasimbiswa, asi kuchinja negadziriro mafaira panguva chokugadza - kuisa multifunctional Database kwakaoma uye noitika chete kana kudiwa mberi basa. Zvikasadaro funga zvimwe embodiments.

chinyorwa vapepeti

Kuti tione zvinorehwa faira rine SQL, * .sql anogona kuvhurwa kushandisa chero nyore chinyorwa mupepeti akadai "nebhuku rokunyorera", Wordpad, nebhuku rokunyorera kana Vim. Mukuwedzera, chipauro "chero" zvinoreva kuti chinyorwa vapepeti "Linux" anokwanisawo kuvhura uye Edit Database mafaira.

Kunokosha! Mushure Editing faira, iva nechokwadi kuti kuitamba panguva yayo yepakutanga format.

Zvakaipira nzira iyi: kushaya functionality of Database. Kushanda chete pamwe chinyorwa kugutsikana, pasina mukana emamiriro ziviso yokukanganisa kunyora mubvunzo, kana ane chinosimbisa Typos apo mashoko kuchinja. Nokuda kwechikonzero ichi, nokuti Editing SQL mafaira, SQL Databases vari akakodzera.