Kōnae SQL. kōnae SQL whakaahuatanga toronga hōputu

Pātengi - he pūnaha matatini, e roto i ngā mōhiohio i roto i te papa hono. kōnae SQL - hōputu SQL o te raraunga i roto i te pātengi raraunga. I roto i te mau parau te tahi atu, ko reira he kōnae kuputuhi mania ki te huinga o ngā tohutohu mō te mahi tahi me raraunga i roto i tepu.

whakaahuatanga

* Tu hōputu kōnae .sql mō "Hanganga raraunga reo uiui" (kōnae hanganga ko te reo uiui). Hua'tu pā ki te kōnae pātengi raraunga. Oku i ai e ngā mōhiohio kuputuhi, me te he huinga o ngā tohutohu e tukua ana ki te hapai i te reira - ki te rapu, whakarōpū, muku rarangi i te DB (pātengi raraunga), tāpiri mea hou, te hanga tauira e hāngai ana i runga i ngā tawhā i tohua. aroaro te ako i whakaritea i roto i te puka o tauākī reo uiui.

Ko te kōnae SQL tuwhera?

oroko hōputu SQL katoa o nga hōtaka e mahi ki te pātengi raraunga. Tenei rārangi ngā:

• MySQL - tetahi o te tino noa DBMS (pūnaha whakahaere pātengi raraunga). Hototahi ki te pūnaha whakahaere matua katoa.
• Microsoft Office Access - he hōtaka i te huinga whänui o te pūmanawa tari mo Windows.
• PostgreSQL - whakataetae he pātengi raraunga hou me te watea ki MySQL.

He uaua, me te whaihua pātengi multifunctional whakaturia anake, no te te hiahia mō te mahi anō - katoa o enei hōtaka (anake taua Access) kore whakapumautia anake i roto i, engari hanga ano hoki whakatikatika ki te kōnae pūnaha i roto i te tāutanga. whakaaro te kore atu taatou.

ētita kuputuhi

I roto i te tikanga ki te kite i te aha kei te kōnae SQL, * e taea te whakatuwheratia .sql te whakamahi i tetahi ētita kuputuhi ohie pērā i "Pukatuhi", Pukakupu, Pukatuhi VIM ranei. I tua atu, i te kupu āhua "tetahi" te tikanga e taea ki te whakatuwhera me ngā kōnae whakatika pātengi raraunga ētita kuputuhi "Linux" Ko ano hoki.

Nui! I muri whakatika te kōnae, kia mohio ki te pupuri i te reira i roto i tona hōputu taketake.

Ko te ngoikoretanga o tenei tikanga: te kore o taumahinga o te pātengi raraunga. Whai ki te mahi anake ki te ihirangi kuputuhi, i waho te pea o te pūnaha o te whakamōhiotanga o te hapa, ki te tuhituhi i te uiui, he typos ahungarua ka huringa raraunga ranei. Hoki tenei take, mo te whakatika kōnae SQL, he pai ake hāngai pātengi raraunga SQL.