Ko te tino wātea Ka āhua te pūāhua SQL
E whakahauhau ana te SQL i roto i tō tātau kaitiaki - te whakahauhau i ngā kupu kī, ngā rārangi-whakahaere me te whakawhāiti, me te kore e whakarewaina.
He pēhea te mahi
- Paki i tōna SQL. Ka whakawātea tētahi kīanga HANGĀ, HONGĀ rānei i roto i te kāwai.
- Kāhua. Ka pā ki te Wāhanga ki ngā kupu kī nui, ka whakaroa ngā wae ki ngā raina hōu me te whakawhāiti.
- Ko te hua ka tāruatia. Ko te tārua o te pātai mārō. Ka haere katoa i roto i tōmu kaitiaki - kāore he mea whakarewa.
Mo tēnei utauta
Ka huri i tētahi pātai SQL-line-only ki tētahi mea e taea e koe te whakaako. Ka whakataki i tētahi kīanga, ā, ka whakawhāiti te tātai i ngā kupu kī, ka whakatakoto i ia kupu nui - SELECT, FROM, WHERE, te JOINs, GROUP BY, ORDER BY, AND/OR me ētahi atu - i runga i tōna raina, ā, ka whakawhāiti i ngā ihirangi o ngā kōwae. Ko ngā aho, ngā tohu whakahua me ngā kōrero e waiho ana i te kore. Ka whakaaetia e ngā kōwhiringa hōhonu kia huri i ngā kupu kī ki te āhua iti, ā, ka kōwhiria he mokowā 2, 4-wā, taupānga rānei. Ka haere katoa i roto i tōna kaitiaki.
He aha te whakamahinga o te tangata mo ia
- Ka taea te whakamātautau i tētahi pātai-wairangi kotahi mō tētahi arotakenga waehere
- Whakawaenga i te kupu kī ki runga i tētahi rōpū SQL
- He mārō te pātai i mua i te tāpoi ki roto i tētahi tāke, tuhinga rānei
- Whakawhāiti i tētahi mekameka roa WHERE / JOIN hei whakarerekē i a ia