Oku kubhaliwe Iindidi zentsimi yedatha, ineenjongo zokubonelela umfundi zezona zixhaphakileyo kwaye zisetyenziswa kwicandelo lenkqubo.
Iindidi zamabala kwindawo yogcino lwedatha
Ngaphambi kokuba sazi ukuba zeziphi iintlobo zentsimi kwindawo yogcino lwedatha, siqala ukuba yindawo yogcino lwedatha (i-BBDD), ibhekisa kuthotho lweedatha ezifanayo kwaye zibhalisiwe ngendlela ecwangcisiweyo eqhutywa emva koko, ukwenziwa kwale datha , Iya kuxhomekeka kwiinjongo ezibekiweyo zokufezekisa imveliso.
Isiseko sedatha senziwe ngeetafile ezahlukeneyo ezinenjongo yokubhalisa ngokomsebenzi weempawu zabo eziyilelwe zona.
Sincoma inqaku elilandelayo Iindidi zedatha kwi-mysql.
Uhlobo lwamaxabiso arekhodwa kwicandelo ngalinye kufuneka luthathelwe ingqalelo, isiseko sedatha sisebenza ngolwazi olwahlukileyo, kubalulekile ukuba uqaphele ukuba kuya kufuneka kuboniswe ukuba loluphi uhlobo lwexabiso olufakelweyo, olulungiselela ukukhangela okuzayo kunye fumana ezona ziphumo zibalaseleyo kwimemori.
Ezona ntlobo zaziwayo zedatha ziboniswa apha ngezantsi, ezizezi:
I-Alphanumerics
Bonke banamanani kunye noonobumba, banokubonakaliswa ngesithuba sabalinganiswa abangama-225.
Amanani
Ngokubhekisele kumanani, ziindidi ezahlukeneyo, ngakumbi amanani apheleleyo angenazo iidesimali, kunye neenombolo zokwenyani ezimelwe ziidesimali.
Iibhothi
Ngamacandelo apho iindlela ezimbini zibhalisiweyo: Ewe okanye Hayi, kuyinyani okanye bubuxoki.
Imihla
Yimimandla emiselwe ukurekhoda imihla, ethi iququzelele ukuxhaphazwa kwabo kamva; ukugcina imihla ngale ndlela kunika ithuba lokuhlela iirekhodi ngemihla okanye ukubala iintsuku phakathi kwemihla.
Imemos
Ibhekisa kumabala e-alphanumeric aneendawo ezingenamda, nangona kunjalo umqobo abanayo kukuba abanakudweliswa.
Ezandayo
La ngamacandelo amanani apheleleyo anyusa ixabiso lawo ngeyunithi kwirekhodi nganye efakiweyo, isibonelelo abasibonisayo kukuba basebenze njengesazisi, kuba bakhethekile kwirekhodi ethile.