Rorohiko, Hōtaka
Mauī uru (SQL) - he tauira, te whakaahuatanga taipitopito, te whakamahi o te hapa
I roto i tetahi pātengi raraunga tūhonohono tūturu, tohaina ngā mōhiohio katoa i runga i te tepu motuhake. E whakatakotoria tokomaha o nga papa mai i roto i te kaupapa kōrero ki ia atu. Heoi, ki te awhina o ka uiui te Sql ko reira rawa e taea ki te hoatu i te hono i waenganui i te raraunga, e kore pūmau i roto i te ara iahiko. mahi tenei e te raveraa i te hononga uru, e taea ai e koe te hanga i tētahi hononga i waenganui i tetahi maha o tepu, me ara hono mōhiohio ngali rerekē.
Ka kōrero tēnei tuhinga āta pā ana ki te to waho maui uru atu. I mua i puta ki te whakamārama o tenei momo o te hononga, tāpiri i roto i te tahi mau tepu pātengi raraunga.
Teuteu nga tepu e tika ana
Hei tauira, i roto i to tatou pātengi raraunga, i reira he pārongo e pā ana ki te iwi, me o ratou hoko whare. Whakarāpopototanga i runga i te papa e toru: iwi (iwi), Realty (hoko whare), Realty_peoples (hononga tepu, iwi nei i te mea taonga no ki). Me kī i te raraunga e whai ake nei rongoa i roto i nga papa o te iwi:
iwi | ||||
id | L_name | F_name | Middle_name | Birthday |
1 | Ivanova | Daria | B. | 07/16/2000 |
2 | Pugin | Vladislav | Nikolaevich | 29.01.1986 |
3 | Evgenin | Alexander | Federovich | 04/30/1964 |
4 | Annina | aroha | P. | 31.12.1989 |
5 | Gerasimovsky | tumanako | P. | 14.03.1992 |
6 | Gerasimovsky | Oleg | Albertovich | 01/29/1985 |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 |
8 | Sukhanovskaya | Julia | Y. | 01.10.2001 |
whenua Real:
Realty | |
id | wāhitau |
1 | Arkhangelsk, ul. Voronin, d. 7, kv.6 |
2 | Arkhangelsk, ul. Severodvinskaya, d. 84, q. 9 BR. 5 |
3 | Arkhangelsk rohe, Severodvinsk, st. Lenin, d. 134, q. 85 |
4 | Arkhangelsk rohe, Novodvinsk, ul. Proletarshaya, d. 16, q. 137 |
5 | Arkhangelsk, pl. Terekhina, d. 89, q. 13 |
Whanaunga iwi - rawa:
Realty_peoples | ||
id_peoples | id_realty | momo |
7 | 3 | rangatiratanga tahi Tapeke |
8 | 3 | rangatiratanga tahi Tapeke |
3 | 5 | taonga |
7 | 1 | taonga |
5 | 4 | wāhanga noa |
6 | 4 | wāhanga noa |
Mahue uru (Sql) - Whakamārama
pūhui mahue He te wetereo e whai ake nei:
Table_A TO'OHEMÁ Hono table_B [{ON paparangi} | {TE spisok_ ki tolbtsov}] |
Na schematically e whai ake:
Na whakamaoritia tenei faaiteraa te rite "Tīpakohia katoa, kaore he aweretanga, raina o te Ripanga, ka Ripanga B ki te whakaatu anake nga rarangi ōrite o te paparangi. Ki te kitea te tepu i roto i te tepu string mō takirua A, ka whakakiia te pou hua Kore - uara ".
Nuinga o ngā wā, ka tohua te hononga mahue te ON, te whakamahi i te whakamahia anake ka ko te taua nga ingoa tīwae, whakaritea nei ki te hanga i te hononga.
Mauī uru - tauira o te whakamahi
Ki te hononga o te maui e taea e matou te titiro, te iwi katoa i te rārangi, ki te reira taonga Iwi. Ki te mahi i tenei i roto i te maui uru tauira rapu SQL:
Iwi Tīpakohia. *, Realty_peoples.id_realty, Realty_peoples.type MEI Iwi TO'OHEMÁ Hono Realty_peoples ON Peoples.id = Realty_peoples.id_peoples; |
Ki te hua e whai ake nei:
Query1 | ||||||
id | L_name | F_name | Middle_name | Birthday | id_realty | momo |
1 | Ivanova | Daria | B. | 07/16/2000 | ||
2 | Pugin | Vladislav | Nikolaevich | 29.01.1986 | ||
3 | Evgenin | Alexander | Federovich | 04/30/1964 | 5 | taonga |
4 | Annina | aroha | P. | 31.12.1989 | ||
5 | Gerasimovsky | tumanako | P. | 14.03.1992 | 4 | wāhanga noa |
6 | Gerasimovsky | Oleg | Albertovich | 01/29/1985 | 4 | wāhanga noa |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 | 1 | taonga |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 | 3 | rangatiratanga tahi Tapeke |
8 | Sukhanovskaya | Julia | Y. | 01.10.2001 | 3 | rangatiratanga tahi Tapeke |
Ka rite ki kite tatou, Ivanova Darya Pugin Vladislav me Anninoy Lyubovi rēhita No tika hoko whare.
Na te aha e kua riro matou, te whakamahi i te roto uru roto uru atu? Ka rite ki matau koutou, katia reira rarangi ōrite-kore, na e toru i roto i o matou tauira whakamutunga e noa kia maturuturu iho:
Query1 | ||||||
id | L_name | F_name | Middle_name | Birthday | id_realty | momo |
3 | Evgenin | Alexander | Federovich | 04/30/1964 | 5 | taonga |
5 | Gerasimovsky | tumanako | P. | 14.03.1992 | 4 | wāhanga noa |
6 | Gerasimovsky | Oleg | Albertovich | 01/29/1985 | 4 | wāhanga noa |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 | 1 | taonga |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 | 3 | rangatiratanga tahi Tapeke |
8 | Sukhanovskaya | Julia | Y. | 01.10.2001 | 3 | rangatiratanga tahi Tapeke |
e mea he e tutuki hoki te putanga tuarua o nga tikanga o to tatou raruraru. Heoi, ki te timata tatou ki te tāpiri i runga i tetahi atu, me tetahi atu tepu, e toru iwi i te hua kua kua ngatangatá. Na reira, i roto i te mahi, ka whakakotahi tepu maha nui atu pinepine whakamahia hononga Maui me Matau atu roto uru atu.
E tonu ki te titiro ki te maui uru tauira SQL. Āpiti te tepu ki wāhitau o matou whare:
Iwi Tīpakohia. *, Realty_peoples.id_realty, Realty_peoples.type, Realty.address MEI Iwi TO'OHEMÁ Hono Realty_peoples ON Peoples.id = Realty_peoples.id_peoples TO'OHEMÁ Hono Realty ON Realty.id = Realty_peoples.id_realty |
Na whiwhi tatou i te ahua e kore e anake o te ture, engari ano hoki te wāhitau o hoko whare:
Query1 | |||||||
id | L_name | F_name | Middle_name | Birthday | id_realty | momo | wāhitau |
1 | Ivanova | Daria | B. | 07/16/2000 | |||
2 | Pugin | Vladislav | Nikolaevich | 29.01.1986 | |||
3 | Evgenin | Alexander | Federovich | 04/30/1964 | 5 | taonga | Arkhangelsk, pl. Terekhina, d. 89, q. 13 |
4 | Annina | aroha | P. | 31.12.1989 | |||
5 | Gerasimovsky | tumanako | P. | 14.03.1992 | 4 | wāhanga noa | Arkhangelsk rohe, Novodvinsk, ul. Proletarshaya, d. 16, q. 137 |
6 | Gerasimovsky | Oleg | Albertovich | 01/29/1985 | 4 | wāhanga noa | Arkhangelsk rohe, Novodvinsk, ul. Proletarshaya, d. 16, q. 137 |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 | 3 | rangatiratanga tahi Tapeke | Arkhangelsk rohe, Severodvinsk, st. Lenin, d. 134, q. 85 |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 | 1 | taonga | Arkhangelsk, ul. Voronin, d. 7, kv.6 |
8 | Sukhanovskaya | Julia | Y. | 01.10.2001 | 3 | rangatiratanga tahi Tapeke |
Arkhangelsk rohe, Severodvinsk, st. Lenin, d. 134, q. 85 |
Mauī uru - te whakamahi angamaheni o hapa: tepu tukanga muhu
hape Basic hanga i te waho maui uru papa, e rua:
- Tika tīpakohia te tikanga o tepu mo te mea i ngaro raraunga.
- Hea hapa ka whakamahi i te uiui ki te whakauru tepu.
A feruri i hape tuatahi. I mua ki te whakatau o tetahi raruraru kia mārama mohio ki e te mea e hiahia ana tatou ki te tiki i roto i te mutunga. I roto i tenei tauira i runga, ka mau matou katoa kotahi tetahi o te iwi, engari tino ngaro te mōhiohio e pā ana ki te ahanoa raro i te tau 2, nei rangatira kihai i kitea.
Ki te oho matou te tepu i roto i te uiui i roto i te tahi mau wahi, a e tīmata ki te «... Mai i mahue uru Iwi Realty ...» tetahi taonga kotahi, kua kore i pai ngaro matou, e kore koe e korero ki e pā ana ki te iwi.
Otiia e kore e e mataku o te hononga maui, whakawhiti ki tonu waho, ngā nei i roto i nga hua, me te ōrite, me kahore te rārangi ōrite.
I muri i te katoa, te rōrahi o te tauira , ko te maha rawa nui, a ko mau maumau raraunga anō. Ko te mea matua - ki te feruri i roto i te mea e hiahia ana koe ki te tiki i te hua: o te iwi katoa ki te rārangi o ratou taonga e wātea ana te rārangi taonga katoa ki o ratou rangatira (ki te tetahi) ranei.
Mauī uru - te whakamahi angamaheni o hapa: he tika Tono ka whakanoho i te tikanga i roto i te hea
Kei te whai pānga te hapa tuarua hoki ki te ngaronga o ngā raraunga, me he kahore tonu tonu kitea.
Kia haere hoki a ki te uiui, ka mahue matou mā hononga riro raraunga mo nga iwi katoa, me to ratou taonga ngā. Kia mahara ki te whai ake ki maui uru tauira SQL:
MEI Iwi TO'OHEMÁ Hono Realty_peoples ON Peoples.id = Realty_peoples.id_peoples; |
Pea e hiahia ana tatou ki te whakamārama i te tono, me te e kore putanga te raraunga, te wahi te momo o te ture - "Āhuatanga". Ki te tatou tāpirihia noa, whakamahi mahue uru SQL, he tauira o te huru e whai ake nei:
...
Hea momo <> "Āhuatanga" |
ka ngaro tatou te raraunga i runga i te iwi e whai kahore taonga, no te mea e kore e whakaritea te korengia uara korenga e whai ake:
Query1 | ||||||
id | L_name | F_name | Middle_name | Birthday | id_realty | momo |
5 | Gerasimovsky | tumanako | P. | 14.03.1992 | 4 | wāhanga noa |
6 | Gerasimovsky | Oleg | Albertovich | 01/29/1985 | 4 | wāhanga noa |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 | 3 | rangatiratanga tahi Tapeke |
8 | Sukhanovskaya | Julia | Y. | 01.10.2001 | 3 | rangatiratanga tahi Tapeke |
Hei ārai i ngā hapa i puta mo tenei take, ko reira pai ki te whakaturia te huru whiriwhiri tonu ki runga ki te hononga. whakaaro tatou ki te whakaaro i te whai ake ki te maui uru tauira SQL.
Iwi Tīpakohia. *, Realty_peoples.id_realty, Realty_peoples.type MEI Iwi TO'OHEMÁ Hono Realty_peoples ON (Peoples.id = Realty_peoples.id_peoples ME momo <> "Āhuatanga") |
Ka waiho i te hua e whai ake:
Query1 | ||||||
id | L_name | F_name | Middle_name | Birthday | id_realty | momo |
1 | Ivanova | Daria | B. | 07/16/2000 | ||
2 | Pugin | Vladislav | Nikolaevich | 29.01.1986 | ||
3 | Evgenin | Alexander | Federovich | 04/30/1964 | ||
4 | Annina | aroha | P. | 31.12.1989 | ||
5 | Gerasimovsky | tumanako | P. | 14.03.1992 | 4 | wāhanga noa |
6 | Gerasimovsky | Oleg | Albertovich | 01/29/1985 | 4 | wāhanga noa |
7 | Sukhanovskaya | Jury | A. | 09/25/1976 | 3 | rangatiratanga tahi Tapeke |
8 | Sukhanovskaya | Julia | Y. | 01.10.2001 | 3 | rangatiratanga tahi Tapeke |
Ko te kupu, mā te whai i te kuware ki te maui uru tauira SQL, riro matou he rārangi o nga iwi katoa, neke atu, tetahi o enei āhuatanga i roto i te tika / rangatiratanga tahi.
Ka rite ki te mutunga e hiahia ana ahau ki te haapapû kotahi ano e hiahia i te tauira o tetahi mōhiohio i te pātengi raraunga ki te kia tangohia kawenga. He maha onäianei whakatuwheratia i roto i te mua o tatou ki te maui uru tauira ohie SQL, te whakamārama o i tetahi - i mua i timata koe ki te tuhituhi noa uiui taketake, koutou me āta ki te matau ki ta tatou e hiahia ana ki te tiki i roto i te mutunga. Ngā manaakitanga!
Similar articles
Trending Now