Peke atu ki te ihirangi
Kaitahuri Kōnae Koreutu

Kaiwhakahōputu SQL

Whakahōputuhia, whakapaipaihia hoki ngā patai SQL mā te whakamahi i ngā kupumatua tika me ngā reta matua kia māmā ai te pānui me te arotake. He taputapu kore utu i roto i te pūtirotiro.

Mō tēnei kaitahuri

Te mahi a te tahuritanga SQL ki Formatted

Format and beautify SQL queries with proper indentation and uppercase keywords for readability and review. Free in-browser tool.

Tukua he kōnae SQL ki te wāhi mahi i runga ake nei, ā, ka puta mai i te kaitahuri he kōnae Formatted i roto tonu i tō pūtirotiro. Ka rere ā-rohe te tahuritanga - kāore tō kōnae e wehe atu i tō pūrere, kāore he pūkete e hiahiatia ana, ā, kāore he rohe tukuake.

  • tūmataiti — ka mahia katoatia te tukatuka i roto i tō pūtirotiro.
  • Koreutu — kāore he rēhitatanga, kāore he tohuwai, kāore he rohenga o ia rā.
  • Tere — kāore he wā tukuake, kāore he rarangi tūmau.

Aratohu taahiraa-i-te-taahiraa

Me pēhea te huri i te SQL ki te Formatted

1

Tukuake ō kōnae

Tōia me te maturuturu i ō kōnae ki te wāhi mahi i runga ake nei, pāwhiritia rānei hei tīpako i aua kōnae mai i tō pūrere.

2

Whakatikatikahia ngā tautuhinga (whiringa kore)

Whirihorahia ngā kōwhiringa, ngā manakohanga rānei mō tō tahuritanga, tō tataunga rānei.

3

Tikiake i te hua

Pāwhiritia te pātene mahi, ka tatari kia oti te tukatuka, kātahi ka tikiake i tō kōnae whakamutunga.

Ngā Pātai Auau

Ngā Pātai Auau

He kore utu te whakamahi i tēnei taputapu?

Ae, he kore utu tā mātou taputapu, kāore he rohe huna, he tohuwai rānei.

He haumaru aku kōnae?

Ae. Ka tukatukahia ngā kōnae katoa i tō wāhi tonu, me te kore e tukuna ō kōnae ki tētahi atu wāhi.

Ka mahi tēnei i runga i te waea pūkoro?

Ae, ka pai te mahi a tā mātou tūāpapa i runga i tētahi taputapu hou, tae atu ki ngā waea atamai me ngā papa.