Cov lus yog ib qho tseem ceeb ntawm cov ntaub ntawv, uas muaj cov ntaub ntawv tseem ceeb. Tag nrho lwm yam khoom siv database xws li cov lus nug, cov ntawv qhia, thiab lwm yam tau ua raws ntawm cov ntxhuav.
Tsim nyog
txuj ci hauv kev ua haujlwm nrog MySql
Cov Lus Qhia
Kauj ruam 1
Siv Cov Lus Qhia Hloov Hloov los hloov kho cov ntaub ntawv hauv cov kab. Koj tuaj yeem tsim cov lus txib no raws li hauv qab no: Hloov kho, tom qab ntawd nkag mus rau qhov yuav tsum tau muaj kev hloov kho rau lub rooj ntawv database.
Kauj ruam 2
Teeb tsa qhov muaj feem thib ntawm qhov lus txib no, piv txwv li, Low_priority tau teeb tsa thaum hloov kho lub rooj yuav raug ncua kom txog thaum lwm cov ntawv sau tiav ua haujlwm ntawm lub rooj.
Kauj ruam 3
Yog tias tsim nyog, teeb tsa tus txheej txheem tsis suav, yog tias lub rooj ntawv muaj cov cim tshwj xeeb thiab cov nuj nqis tsis zoo tshwm sim thaum hloov tshiab, tom qab ntawd cov lus txib yuav tsis tiav thiab cov nqi no yuav tsis hloov.
Kauj ruam 4
Sau lub npe rau lub rooj, rau qhov no siv Tbl_name parameter. Tom qab ntawd teeb tsa lo lus tseem ceeb Txheej, tom qab ntawd ntxiv cov npe thaj chaw yuav raug hloov tshiab, nrog rau cov chaw sau hloov kho tshiab lawv tus kheej hauv daim ntawv hauv qab no: Teeb "Sau lub npe teb" = 'tus nqi'. Piv txwv li, txhawm rau hloov teb chaw nyob hauv txhua cov ntaub ntawv ntawm Cov Neeg Siv lub rooj, khiav cov lus txib: Hloov tshiab 'cov neeg siv' teeb 'lub teb chaws' = 'Tebchaws Asmeskas'. Yog tias tus nqi tshiab raug xa los ntawm Cov Lus Qhia Hloov Tshiab nws zoo ib yam li daim qub, tom qab ntawv no yuav tsis hloov.
Kauj ruam 5
Siv cov piv txwv hauv qab no txhawm rau txhawm rau nce lub hnub nyoog ntawm txhua tus neeg siv teev hauv lub rooj ua ib xyoos: Hloov tshiab 'cov neeg siv' Teeb 'hnub nyoog' = 'hnub nyoog' + 1. Nyob rau hauv tib txoj kev, koj tuaj yeem ua ib qho kev ua lej ua haujlwm nrog cov nuj nqis ntawm cov rooj, i.e. hloov kho cov ntaub ntawv siv kev sib npaug, sib faib, kev rho tawm lossis ntxiv rau.
Kauj Ruam 6
Siv qhov twg parameter kom qhia meej cov kev xaiv xaiv rau cov ntaub ntawv yuav tsum tau hloov kho. Txhawm rau muab cov naj npawb ntawm cov kab uas muaj kev sib hloov tau, siv qhov kev txwv tsis dhau. Piv txwv li, koj tuaj yeem hloov kho thawj tsib cov ntaub ntawv hauv ib lub rooj nrog cov lus txib nram qab no: Hloov kho 'cov neeg siv' Teeb 'hnub nyoog' = 'hnub nyoog' +1 Txwv 5.
