Feem ntau, cov ntawv siv cov ntawv muaj cov nqe lus SQL raug siv los tsiv MySQL databases ntawm ib lub server mus rau lwm tus. Txhawm rau thauj cov ntaub ntawv tsis tshua muaj me me rau hauv cov ntawv thov hauv chaw ua haujlwm, cov ntawv siv cov ntawv theem nrab kuj tseem siv. Cov lag luam xa tawm tau yooj yim kho los ntawm phpMyAdmin, ib daim ntawv thov tsim los tswj MySQL databases ncaj qha los ntawm qhov browser.
Cov Lus Qhia
Kauj ruam 1
Yog tias cov chaw tswj hwm tau tuav ntawm lub web server, tom qab ntawd thawj thawj kauj ruam ntawm kev xa khoom tawm koj yuav tsum nrhiav "ntu" ntu hauv tus tswj hwm lub koom haum tswj hwm, thiab hauv nws txuas rau phpMyAdmin. Khiav daim ntawv thov thiab taw rau hauv cov chaw khaws ntaub ntawv uas muaj cov ntxhuav yuav ua lag luam tawm. Qhov kev xaiv ntawm lub hauv paus uas xav tau yog nqa tawm hauv kab ntawv sab laug ntawm daim ntawv thov interface.
Kauj ruam 2
Nyob rau sab saum toj ntawm txoj cai pane, ntawm nplooj ntawv ntawm cov ntaub ntawv xav tau, muaj cov kev txuas rau ntau yam haujlwm - nyem qhov txuas uas hais tias "Export".
Kauj ruam 3
Ntawm nplooj ntawv xa tawm, qhov chaw tau muab faib ua ke rau hauv ob peb block. Hauv qhov block nrog lub npe "Export" xaiv txhua lub rooj uas koj xav tau - koj tuaj yeem nyem "Txuas tag nrho" txuas lossis cim tsuas yog ib feem ntawm cov ntxhuav los ntawm nias rau txhua lub rooj ntawm kev txaus siab thiab tuav cia CTRL tus yuam sij.
Kauj ruam 4
Nyob rau tib lub thaiv ntawm kev teeb tsa, qhia cov hom ntawv rau txuag cov ntaub ntawv raug xa tawm. Rau qhov kev thauj khoom txuas ntxiv ntawm cov ntaub ntawv rau lwm tus rau SQL tus neeg rau zaub mov, tsis muaj dab tsi xav tau hloov - los ntawm lub neej ntawd, hom SQL tau xaiv ntawm no. Thiab kom thauj cov ntaub ntawv rau hauv txhua daim ntawv thov hauv chaw haujlwm, koj yuav tsum xaiv cov ntawv tsim nyog.
Kauj ruam 5
Yog tias hom "SQL" raug xaiv, nplooj ntawv yuav muaj pawg neeg teeb tsa nrog rau kab lus "Txwv". Nws yog qhov tsim nyog los tso cov npov uas tsim nyog rau hauv nws. Kev saib xyuas tshwj xeeb yuav tsum tau them rau ntawm no rau cov chaw hauv seem "Txawv". Lub cim kos tso rau sab nraud ntawm cov ntawv sau "Ntxiv DROP ROOJ" yuav ua rau kev puas tsuaj ntawm cov ntxhuav uas twb muaj lawm nrog tib lub npe ntawm qhov chaw cia tshiab thaum lub sijhawm tom qab thauj khoom ntawm lub chaw khaws ntaub ntawv. Yog tias koj xav kom tsis txhob sau npe, tab sis ntxiv cov ntaub ntawv xa tawm mus rau cov uas twb muaj lawm, tsis txhob xaiv lub thawv no. Qhov kev xaiv "Add IF NOT EXISTS" muaj qhov laj thawj zoo sib xws - thaum muab tso rau lub server tshiab, cov ntxhuav database yuav raug tsim yog tias cov ntxhuav tsis tseem muaj, txwv tsis pub cov ntaub ntawv yuav ntxiv rau cov uas twb muaj lawm.
Kauj Ruam 6
Cov ntaub ntawv exported yuav muab tso rau hauv lub thawv ntawv los ntawm lub neej ntawd. Koj tuaj yeem luam lawv nyob ntawm no, thiab tom qab ntawd, ntawm koj lub siab nyiam, muab tshuaj txhuam lawv rau hauv cov ntawv nyeem ntawv lossis lwm daim ntawv thov chaw haujlwm. Yog koj xav khaws cov ntaub ntawv rau ib daim ntawv, thiab tsis tso saib rau nws, ces tso tus cim rau ntawm "Txuag ua cov ntaub ntawv".
Kauj Ruam 7
Cov kauj ruam kawg hauv kev pib txheej txheem txheej txheem export yog nyem rau ntawm "OK" khawm rau hauv qab ntawm qab txoj cai ppMyAdmin.
