Raws li cov ntaub ntawv khaws cia siv, cov ntaub ntawv tsis tsim nyog sau nyob hauv lawv - rooj, ntaub ntawv, ntawv teev cia, thiab lwm yam. Qee lub sij hawm qhov kev thauj khoom tsis tseem ceeb no ua rau kev poob qis lossis qhov yuam kev hauv cov ntawv thov siv lawv. Cov feem ntau siv MySQL cov ntaub ntawv tswj kev tswj hwm rau kev ceev database yog phpMyAdmin daim ntawv thov.
Nws yog qhov tsim nyog
PhpMyAdmin nkag tau
Cov Lus Qhia
Kauj ruam 1
Tom qab nkag mus rau hauv phpMyAdmin, xaiv cov ntaub ntawv yuav tsum muaj nyob hauv kab ntawv sab laug.
Kauj ruam 2
Yog tias koj xav tau txheeb cov ntaub ntawv los ntawm txhua cov ntxhuav nrog rau cov ntaub ntawv lawv muaj, ces nyem rau kab lus "Cim txhua" txuas nyob hauv qab rooj, thiab tom qab ntawd xaiv kab "Rho tawm" hauv kab ntawv nco nrog "Cov cim" Cov. Cov ntawv thov yuav nug txog kev lees paub ntawm DROP LUB ROOJ thov - nyem "Yes". Tom qab ntawd, ib lub rooj nrog cov txiaj ntsig ntawm kev ua tiav ib qhov kev tshawb fawb SQL kom lwv tag nrho cov ntxhuav yuav tau thauj khoom rau hauv txoj cai ncej.
Kauj ruam 3
Yog tias koj xav rho tawm tsuas yog cov ntaub ntawv muaj nyob hauv cov kab ntawv, tom qab ntawd, zoo li hauv cov kauj ruam yav dhau los, koj yuav tsum nyem qhov txuas "Tshawb xyuas txhua qhov", tab sis xaiv kab "Clear" hauv kab poob. Ntawm chav kawm, rau ob qho tib si rho tawm thiab ua dej ntws yaug, koj tsis tas yuav xaiv tag nrho cov ntxhuav. Koj tsuas yog khij lub thawv rau cov ntxhuav uas koj nyiam.
Kauj ruam 4
Nyob rau hauv tus txheej txheem ntawm kev ua haujlwm nquag nrog lub chaw khaws ntaub ntawv, thaum ntau tus sau thiab rho tawm haujlwm tau ua, "khib nyiab" tseem nyob hauv cov rooj - qee cov kab tsis siv, cov cim ntsuas, thiab lwm yam. Yuav kom thau cov ntxhuav los ntawm txhua qhov tsis tsim nyog, "Xaiv lub rooj zoo siab" tau siv. Txhawm rau siv nws, koj yuav tsum nyem "Tshawb Tag Nrho" dua thiab xaiv kab no ntawm kab tawm hauv qab.
Kauj ruam 5
Yog tias SQL cov lus nug ua rau muaj qhov yuam kev, tom qab ntawd yuav muaj qee qhov kev puas tsuaj rau cov ntaub ntawv khaws cia los ntawm SQL server txog tus qauv thiab indexing ntawm cov ntxhuav database. Hauv qhov no, los ntawm txhaj rau "txuas tag nrho" txuas, koj yuav tsum xaiv cov "Restore table" yam nyob rau hauv daim ntawv nco-down.
