"Cov teb tseem ceeb" hauv lub rooj database yog daim teb cov ntaub ntawv uas kev tswj hwm ntawm cov ntaub ntawv no tsim cov ntaub ntawv pabcuam ntxiv uas pabcuam rau kom nrhiav tau txoj hauv kev kom tau txais cov kab. Cov txheej txheem rov ua dua tshiab raws li cov ntsiab lus ntawm daim teb tseem ceeb, uas DBMS ua tom qab txhua qhov kev hloov pauv ntawm ib lub rooj, yog hu ua kev ntsuas los ntawm lub teb tseem ceeb. Hauv MySQL DBMS, nws yooj yim siv phpMyAdmin daim ntawv thov los tsim cov teb tseem ceeb.
Cov Lus Qhia
Kauj ruam 1
Nkag mus rau phpMyAdmin thiab nkag mus rau qhov chaw khaws ntaub ntawv uas muaj lub rooj koj txaus siab los ntawm nyem rau ntawm kab sib txuas ntawm kab ntawv sab laug ntawm daim ntawv thov interface. Hauv qab pane ntawm nplooj ntawv uas qhib, yuav muaj cov kab npe uas muaj nyob hauv cov ntawv txheeb uas raug xaiv, thiab nyob rau sab xis saum toj yuav muaj ib lub rooj uas muaj cov ncauj lus qhia ntxiv txog lawv. Koj yuav tsum tau nyem rau ntawm txoj kab txuas nrog lub npe ntawm cov lus uas yuav tsum tau nyob hauv kab ntawv sab laug, lossis ntawm lub cim "Tus Qauv" hauv kab xov tooj sib txuas hauv txoj cai thav duab. Raws li qhov tshwm sim, daim ntawv teev cov npe ntawm lub rooj no yuav raug thau rau hauv txoj kab uas yog.
Kauj ruam 2
Yog tias koj yuav tsum ua tus yuam sij ntawm lub teb uas twb muaj lawm, tom qab ntawd koj muaj ntau txoj kev xaiv. Yog tias koj xav tsim tus yuam sij tsuas yog mus ceev rau cov ntaub ntawv tshawb (nws tuaj yeem muaj ob peb tus yuam sij hauv lub rooj tib lub sijhawm), tom qab ntawd nyem rau ntawm "Index" icon hauv kab "Action" ntawm kem xav tau ntawm daim teb. Cov. Daim ntawv thov yuav compose cov lus nug uas yuav tsum tau SQL thiab xa mus rau lub server. Yog tias nws yuav tsum yog tus yuam sij tshwj xeeb, uas cov ntaub ntawv teev cov txheej txheem tau txheeb los ntawm lub neej ntawd (nws muaj tib qho thiab nws hu ua "thawj tus ntsuas"), tom qab ntawd nyem rau ntawm "Primary" icon hauv tib qho "Action".
Kauj ruam 3
Yog tias koj yuav tsum tau ua daim teb tseem ceeb uas tseem tsis tau hauv lub rooj, tom qab ntawd khij lub npov "Thaum pib ntawm lub rooj" thiab nyem "OK" khawm nyob rau tib txoj kab. Hauv daim foos uas qhib, sau rau hauv cov teb nrog cov tsis dhau ntawm thaj teb raug tsim thiab muab ib daim tshev rau hauv kab nrog lub cim "Lub Cim", thiab tom qab ntawd nyem rau "Txuag" khawm thiab daim ntawv thov yuav tsim thiab xa cov ntawv yuav tsum tau SQL cov lus nug.
Kauj ruam 4
Koj tuaj yeem xa daim ntawv thov qhov xav tau ntawm koj tus kheej. Ua li no, nyem rau ntawm SQL txuas thiab ntaus tus ntawv nug uas xav tau nyob hauv kab ntawv cov kab ntawv ntau. Piv txwv li, nws tuaj yeem zoo li no:
ALTER ROOJ `tableOne` DROP PRIMARY QHOV TSEEM TSHUAJ, NTXIV TUS Tseem Ceeb ("login")
Cov lus nug no thim qhov tseem ceeb thawj qhov tseem ceeb hauv lub rooj hu ua tableOne thiab muab thaj teb muaj npe tus ID nkag mus ua thawj tus yuam sij. Txhawm rau xa daim ntawv thov, nyem rau "OK".
