Whakahau Windows papatohu - MySQL

Whanaketanga o te hangarau mōhiohio - tetahi o nga wāhi ārahi o te mahi a te tangata. Na reira, i roto i tenei rohe kei te haumi nui nui o te moni. Mai te timatanga me te rota o ngā mahi rerekē i reira kua whakaritea ki te rā, e tino noho i te oraraa rā o te iwi maha. Heoi, ki te nama i roto i te hangarau, i te maha o ngā raruraru, tetahi o nei - ki te penapena i te nui rawa o te mōhiohio. hangaia Pātengi i ki te whakatau i te āhuatanga.

He tirohanga whānui o ngā pūnaha whakahaere pātengi raraunga

Mai te mea e hāngai ana mō te tenei ra te raruraru o te rokiroki nui o ngā mōhiohio, i reira e maha ngā huarahi ki te whakaoti. arotahi Ia o ratou i runga i te mahi tetahi i te aronga. Heoi, tahi ahua ai ratou he matatini tonu e ohie rokiroki raruraru.

He he he whakarōpū tino, e whakatau i te hiahia mō te pātengi raraunga ngā me DBMS (pūnaha whakahaere pātengi raraunga). Ko te tino noa te whakaaro tēnei wā ki te waiho i te hangarau rokiroki kiritaki-tūmau. Ko ētahi o ēnei te whai ake: Firebird, Interbase, IBM DB2, MS SQL Tūmau, Sybase, Oracle, PostgreSQL, Linter, MySQL. He hiahia i roto i te kōwhiringa muri matou - MySQL, e te kapa tino ki te paerewa SQL. Tenei hangarau Ko tetahi o te rohe tono me te hanga raruraru tino rongonui, me te nuitia whakamahia ki te rutu o te tauine iti.

Kiritaki-tūmau precursors hangarau he kōnae-tūmau pātengi raraunga, e kua ngaro o ratou tūranga e tika ki te maha o drawbacks tīariari, i roto i nei ki te hiahia tohatoha whakatö DBMS pata i runga i ia rorohiko me te kawenga nui i runga i te whatunga rohe paetata, hua i roto i nui haere wa-e kai ana. Tenei rōpū ngā te Microsoft te Access, te Borland he Paradox.

Kei te whiwhi hangarau New rongonui

Heoi, he tau torutoru ki muri reira ko te hangarau matatau te whiwhi e rongonui me te tono mō te whakaoti rapanga iti rohe. Kei te korero tatou e pā ana ki te pūnaha whakahaere pātengi raraunga tāmau. Ko te āhuatanga matua o tenei pātengi raraunga - kahore taha tūmau. Ko te pūnaha iho ko te whare pukapuka, tuku he ara ōrite ki te hapai i nui o te kōrero whakahaeretia i runga i te rorohiko rohe. Faaore i tikanga nga āhuatanga kōnae rauemi tūmau, a nui pai ki te tere hangarau kiritaki-tūmau.

I taea te kite tauira OpenEdge, SQLite, BerkeleyDB, tetahi o nga kōwhiringa Firebird o Kōpekapeka Sav, te Microsoft te Tūmau SQL te Compact, Linter, me te ki tetahi o te kōwhiringa MySQL e kore te kapa e rerekē i te hunga e whakamahia ana i roto i te pātengi raraunga kiritaki-tūmau. Heoi, ngāwari taea pūnaha tāmau ngaro tona hāngaitanga ki te ka mutu te raruraru ki te kia te rohe.

Ko te painga matua o te pātengi raraunga MySQL

pūnaha whakahaere MySQL pātengi raraunga ko tetahi o te hangarau tino rongonui, no te mea e taea te whakahohe reira ki te whakatutuki i te maha nui o ngā mahi. Ki te whakarite tatou i te reira ki te ritenga hou, he mea ka taea ki te tautuhi i te maha o ngā painga nui.

whakaaro te painga matua i roto i te mākete Russian te ki hei tona wātea, mai te mea te reira noa o te tiaki i roto i te nuinga o te wā. Ko te āhuatanga tuarua ko te tere. Ko tētahi o nga pūnaha tino rongonui ko MySQL. Team he nohopuku reira, ki te wa urupare iti. No pānga i runga i te tere o te tukatuka whakahau ki te hono ki te tūmau kiritaki maha i roto i te aratau multithreaded mā te whakamahi i tikanga tautoko InnoDB mō ngā whakawhitinga nohopuku.

Ko te aroaro o te atekōkiri ODBC taea ngā ki faaohie te otinga o ngā raruraru maha. Ko te painga e ngā ano te whakarato o ngā whai wāhitanga o ngā pūkete o te roa pūmau, me te tāupe. Ko te mahi matua o nei te maiohatia rawa nui i roto i hötaka - atanga ki reo C me PHP. Ko te whai wāhitanga e whakaratohia ana e MySQL, whakaaetia ki te whakamahi i tenei pātengi raraunga mo te tokomaha nui o ngā kaiwhakarato o te tukutuku e hautū ratonga.

A mo te ke ohie, te whakawhanake i te moni i roto i ngā hangarau hou o ngā mōhiohio rokiroki, he mea e tika ana ki te ako i te MySQL, nga whakahau SQL me wetereo no te mea he nga tohunga i roto i tenei rohe i roto i te tono nui, me te tino utua hea i roto i te ao. Na reira, ki te tangata hiahia i roto i tenei aronga, kahore utu roa. Me neke tatou ki te ako i teie nei.

He aha e hiahia ahau ki te ako

I mawhiti tuatahi kia mea he e he uaua ki te whaiaro ako-tenei rohe, me te titau kōrero tamau ki te mātanga. Heoi, e kore e pera. hoahoanga Ako me ngā āhuatanga o MySQL, te rōpū matua o te reo uiui me te mea katoa hono ki reira, ka taea e koe ake, paitanga ki te awhina o te kaitohutohu. He mea nui ki te whai i te hiahia me te mau tautooraa ki te neke i runga i. Anake te whaiaro-whanaketanga me te ako o tenei rohe ka tukua ki te whiwhi mōhiotanga hou, ki te whakaū i te pūkenga riro a, pea, tīmata ki te hanga i te mahi, me te neke i roto i tenei aronga.

Hei ako i te whakahau taketake, te tuatahi o te katoa, e hiahia ana koe ki te whai i runga i te ringa i te putanga noa o MySQL papatohu whaipainga. haamata taua tukanga ako ki reira. Ka taea e koe te tiki i te reira i te pae MySQL mōhiohio. Kei te ngāwari tāuta te reira i runga i tetahi pūnaha whakahaere, hanga he tūmau me te kiritaki i runga i te rorohiko kotahi, i te mea tino watea.

Na ka ko reira e tika ana ki te huihui ki te kimi i te ā-whakangungu kei roto ngā mōhiohio taketake e pā ana ki te taiao MySQL. Papatohu whakahau hoki te rangahau taketake, rite ki te tikanga, kei te roto ano hoki ratou. Mōhiohio e pā ana ki tenei he rawa rota. Heoi, e hiahia ana koe ki te haere mai ki te kōwhiringa tino. kia Information kia te aroaro wā me mārama hanganga.

Ki te whai koe i mohio taketake o te reo Ingarihi, ka taea e koe te whakamahi i te tautoko papatohu hanga-i roto i. Hoki tenei whakaaro i reira ko te whakahau awhina motuhake, e āwhina ki te mahino te whakamahi o ngā taputapu MySQL.

Ko te whakahau papatohu matua

He whakawhitinga maeneene i nga āhuatanga taketake, āheinga me hua, ka matou ki te rārangi o whakahau taketake. te tīmatanga Kei MySQL whaipainga kotahi anake te kaiwhakamahi, e te tika whakamahia mo te ako. Tenei kaiwhakamahi ingoa pakiaka, tona kupuhipa he ōrite ki te ingoa.

A, no te e hiahia te rōnihi tuatahi, me te muri o te papatohu MySQL kaiwhakamahi ki te tomo i te kupuhipa pakiaka mo te mahi atu ki te DBMS MySQL. E wātea ana CLI whakahau i muri i anake motuhēhēnga angitu.

I muri i te whakamātautau angitu mō te haratau, ka taea e koe te whakaatu i te whakahau i ngā te whakamahi i te whakahau i te tauturu. I muri i taua, ka te papatohu kia te aroaro ki whakahau ngā katoa me te whakamārama poto o ratou.

me whakahau mana whakaatu

Na e hiahia ana koe ki te haere ki te mahi e whai ake. Ki te mahi i tenei, me tīpako koe i te ngā ranei te waihanga i tētahi pātengi raraunga hōu. Hei tīpako i tētahi pātengi raraunga e tīariari me te whakamahi i te whakamahi whakahau. A i roto i te āputa ki te tomo i te ingoa pātengi raraunga. I te tīmatanga, ko te whaipainga ko reira he kotahi anake - me te whakamātautau ingoa. Na reira, ka titiro i te uiui rite tenei: whakamahi whakamātautau.

Hei waihanga i te pātengi raraunga e hiahia ana koe ki te whakamahi i te whakahau waihanga, tuhu ki tona pātengi raraunga kupu matua, me te te tauwhāiti i te ingoa e tika ana. Ko te hanganga e te puka e whai ake nei: te waihanga Name_of_database pātengi raraunga. Ki te mahi ki te pātengi raraunga hou hanga he reira e tika ana ki te tono mā te whakamahi i te whakamahi whakahau.

Ko te reo e te mahi mō te whakaatu pātengi ngā, tepu, mau taviri tuatahi ranei hononga waho, me te outputting mōhiohio e wātea ana e pā ana ki a ratou i roto i MySQL papatohu. kia timata tonu kapa i roto i tenei take ki te whakaatu i te tono. Hei tauira, ki te whakaatu i te rārangi o pātengi e wātea ana mo te kaiwhakamahi o nāianei, tomo noa i te uiui e whai ake nei: whakaatu pātengi. Hei whakaatu i te tepu nui i muri i te kupu matua huri i te ahanoa whakaatu mā te tuhi tepu.

Team Whakahaere Ripanga

I mua i puta atu, he kotahi ano reira e tika ana ki te haamana'o e te tautukunga ki te paerewa SQL whakarato whai wāhitanga mō ngā, ahakoa o nga pūnaha pātengi raraunga, me te whakahaere. ka mahi Tono whakawhanakehia i roto i tetahi taiao e tautoko ana i te paerewa SQL, pai (ina ko te pātengi raraunga e wātea ana, me nga tepu) i roto i te taiao MySQL. whakahau papatohu Windows e rerekē i te hunga e whakamahia ana i roto i te tahi atu pūnaha whakahaere kahore.

Ripakaute i reira e he maha o whakahau tauwhāiti e, te mea e iriti tatou ratou ki Ingarihi, hoki ratou e korero. I runga i te whakahau waihanga whakahuatia i runga ake. taea hoki te te whakahohe te reira ki te tāpiri tepu ki te pātengi raraunga hanga i mua. Hei tango ahanoa pātengi raraunga pērā i ngā ripanga me whakamahia whakahau te maturuturunga iho, ki nei tapiritia te ingoa o te ahanoa e ngaro. Tauira: maturuturunga ingoa _ o _ koutou _ tepu.

tono wetereo ki te tūmau pātengi raraunga e te hanganga whānui tonu. Na reira, he tono, hangaia i runga i Windows, a ka mahi pai i roto i te MySQL Linux papatohu. Teams peratia tūmau kahore hapa i roto i te kotahi pūnaha whakahaere e kore e taea e meinga hapa i roto i ētahi atu.

Tīpako rōpū

Ko Ko te tino nui wetereo ripanga whakahau ohie nui, - tīpako i te rōpū. Kei te whakamahia te reira ki te tīpako raraunga i te pātengi raraunga. Ko te wetereo taketake ko e whai ake: tīpako * i tepu _ ingoa. Na roto i te te tuku i te tono ki te tūmau pātengi raraunga, me te tiki i te kiritaki te pūkete katoa rongoa i roto i te tepu.

E rave rahi te iwi e kore whakaaro, engari ka e whakamahia tonu tirotiro rauemi Internet MySQL faaue. whakamahi i te PHP-uiui te wetereo reo SQL ki te whakaatu i te tirotiro o te whaiaronga o ngā toa ipurangi rongo ranei i roto i whatunga pāpori. Engari o te "*" i muri i te tīpako horo'a nei, kia rite ki te tikanga, he rārangi o nga mara matua o te tepu e rave rahi papa o raraunga ranei ki te tukatuka. I roto i te take o te tīpako i tepu maha, uru he paihere motuhake, e te kaimahi ki te hono a ratou i runga i te hononga e wātea ana waho. Heoi, e taea te puta ke tenei huru takitahi tohu e āpure kia kawea i roto i te hononga.

Tautuhi i te here tīpako

I te tahi taime i reira he he āhuatanga i reira te whakautu riro i te tūmau pātengi raraunga kei raraunga tārite. I roto i te tikanga hoki ki te kaiwhakamahi kia kitea tāurunga ahurei anake, mā te whakamahi i tuku motuhake. Kei te whakanohoia te reira i te aroaro o te rārangi o ngā āpure tonoa a kaimahi hei āwhina ki te huna tārua.