Ib qho ntawm feem ntau siv cov kev tswj fwm database (DBMS) hnub no yog MySQL. Thaum kawg tab sis tsis tsawg kawg, nws cov koob meej tau yooj yim los ntawm kev tsim qauv thiab nquag txhim kho daim ntawv thov PhpMyAdmin, uas tso cai rau koj tswj hwm databases ncaj qha hauv qhov browser. Nws txoj kev sib tshuam yooj yim ua rau nws muaj peev xwm los tsim cov lus nug SQL tsim nyog txawm tias tsis muaj kev paub txog hom lus no.
Cov Lus Qhia
Kauj ruam 1
Rub lub PhpMyAdmin interface, nkag rau hauv thiab nyem ib qho uas koj xav tau los ua cov lus nug SQL hauv cov npe teev npe. Daim ntawv no tau muab tso rau hauv kab laug sab ntawm daim ntawv thov interface. Kev ntu zuj zus ntawm kev nqis tes ua ntxiv yog nyob ntawm yam koj xav thov tsim.
Kauj ruam 2
Yog tias cov lus nug yog tshawb rau tus nqi uas koj tau teev nyob rau hauv txhua daim teb ntawm lub rooj ntawm cov ntaub ntawv xaiv, tom qab ntawd nyem rau "Tshawb" tab hauv cov ntawv qhia ntawm hom txoj cai. Hauv kab ntawv kab ntawv, nkag mus rau tus nqi uas yuav tsum tau xa hauv cov lus nug, hauv kab ntawv Tshawb Nrhiav, xaiv ib qho ntawm cov kev tshawb nrhiav, thiab hauv cov npe kab ntawv rau cov ntaub ntawv no, xaiv txhua lossis tsuas yog ib feem ntawm cov rooj uas yuav tsum ua mus rau cov nrhiav tau. Tom qab ntawv nyem khawm "OK" thiab daim ntawv thov, raws li cov ntaub ntawv koj nkag mus, yuav sau ib qho kev thov rau txhua tus ntxhuav xaiv thiab xa lawv txhua tus xa mus. Qhov tshwm sim rau txhua lub rooj yuav muab sau ua ke hauv ib lub rooj dav dav, thiab los ntawm txhaj rau "Xaiv" khawm hauv txhua kab ntawv koj yuav pom cov ntawv ntawm cov lus nug SQL sau rau lub rooj uas raug xaiv thiab cov txiaj ntsig tshawb hauv nws. Yog tias tsim nyog, txoj cai thov tsim txoj cai no tuaj yeem theej thiab siv raws li koj qhov kev txiav txim.
Kauj ruam 3
Yog tias cov lus nug yuav tsum ntxiv cov kab tshiab rau ib qho ntawm cov lus, ces xaiv lub rooj thiab nyem rau ntawm "Ntxig" tab hauv cov ntawv qhia ntawm txoj cai thav duab. Hauv nplooj ntawv qhib nrog daim foos, sau cov nqi ntawm cov teb sib haum rau cov teb ntawm lub rooj thiab nyem khawm "OK". PhpMyAdmin yuav compose lus nug, xa mus rau tus neeg rau zaub mov thiab qhia koj cov lus nug SQL nws tus kheej thiab cov ntawv ceeb toom ntawm nws ua tiav. Qhov kev thov no tseem tuaj yeem luam tawm thiab siv tau yav tom ntej, piv txwv li, txhawm rau nkag nrog PHP tsab ntawv uas ua haujlwm nrog lub hauv paus rau hauv txoj cai.
Kauj ruam 4
Yog tias cov lus nug yuav tsum tau txais cov ntaub ntawv ntawm qee tus lej ntawm cov kab ntawv ntawm qhov chaw khaws ntaub ntawv, tom qab ntawd xaiv cov rooj uas xav tau thiab nyem rau ntawm "Browse" tab. Daim ntawv thov yuav tsim ib qho kev thov, xa mus rau tus neeg rau zaub mov, thiab tom qab ntawd qhia qhov kev thov nws tus kheej, ntxiv rau cov lus teb tau txais nyob rau hauv daim ntawv tabular.
Kauj ruam 5
Yog tias koj xav nkag mus rau cov lus nug cov ntawv sau koj tus kheej, ces xaiv lub "SQL" txuas. Qhov kev zov me nyuam yuav nthuav qhia koj nrog ntau kab kab lus rau kev nkag mus rau cov lus nug, rau hauv ib qho qauv uas yuav muab tso rau - cov qauv ntawm qhov yooj yim, tab sis feem ntau siv cov lus nug uas xaiv cov rooj sib txig. Tom qab hloov kho lub stub raws li xav tau, nyem "OK" khawm xa nws mus rau SQL tus neeg rau zaub mov.
