Yuav Ua Li Cas Rau Import Cov Ntaub Ntawv

Cov txheej txheem:

Yuav Ua Li Cas Rau Import Cov Ntaub Ntawv
Yuav Ua Li Cas Rau Import Cov Ntaub Ntawv

Video: Yuav Ua Li Cas Rau Import Cov Ntaub Ntawv

Video: Yuav Ua Li Cas Rau Import Cov Ntaub Ntawv
Video: Kev qhia yuav ua li cas thaum lub caij pojniam muaj menyuam ntawv yuav tau ua li cas 19 July 2019 2024, Hlis ntuj nqeg
Anonim

Txhawm rau import MySQL databases los ntawm cov ntaub ntawv muaj cov nqe lus SQL, nws yooj yim tshaj plaws los siv phpMyAdmin - qhov tseeb, daim ntawv thov no tau dhau los ua tus qauv hauv ntiaj teb. Nws tso cai rau koj los ua cov haujlwm tsim nyog ncaj qha hauv lub browser window thiab muaj nyob rau hauv cov txheej txheem yooj yim ntawm cov cuab yeej tau muab los ntawm feem ntau kiag li ntawm cov muab kev pabcuam hosting. Qhov kev pabcuam phpMyAdmin tau faib los ntawm tus tsim khoom siv pub dawb thiab tuaj yeem ntsia tau rau ib qho system.

Yuav ua li cas import ib cov ntaub ntawv
Yuav ua li cas import ib cov ntaub ntawv

Tsim nyog

phpMyAdmin app nkag tau

Cov Lus Qhia

Kauj ruam 1

Ntsaws phpMyAdmin lub tsev nplooj rau hauv koj lub browser, nkag mus rau koj tus username thiab password thiab nkag mus rau lub tswj kev siv ntawm daim ntawv thov no.

Kauj ruam 2

Tsim ib qho chaw khaws ntaub ntawv nrog lub npe yam xav tau yog tias CREATE DATABASE cov lus txib tsis suav nrog hauv cov ntawv xa tuaj. Txhawm rau ua qhov no, sau lub npe hauv daim teb hauv qab "Database" daim ntawv lo rau sab xis ntawm phpMyAdmin lub ntsiab nplooj ntawv thiab nyem rau "Tsim".

Kauj ruam 3

Nyem Txuas Ntshuam Txuas hauv txoj cai thav duab ntawm lub interface. Yog tias koj tau tsim ib qho chaw khaws ntaub ntawv ua ntej, tom qab ntawd koj yuav tsum nrhiav nws nyob rau kab saum toj kawg nkaus ntawm cov lus txib, thiab yog tias tsis muaj cov kauj ruam no, koj yuav pom qhov txuas ntawd nyob hauv qab ntawm nplooj ntawv tseem ceeb.

Kauj ruam 4

Tshawb xyuas yog tias koj yuav tsum faib cov ntaub ntawv txawv teb cov ntaub ntawv rau hauv ntau qhov chaw. Qhov no yuav tsim nyog yog tias lawv qhov ntau thiab tsawg dua qhov txwv tsis pub dhau nyob hauv cov teeb tsa neeg rau zaub mov. Qhov loj tshaj plaws pub kom pom loj tuaj yeem pom hauv cov ntawv sau rau hauv cov cim kab tuav rau sab xis ntawm "Xauj" khawm. Yog tias tsim nyog, cais cov kab ntawm SQL kab lus los ntawm cov ntaub ntawv ntawm cov ntawv hauv txoj hauv kev sib txawv thiab txuag lawv mus rau hauv cov ntawv me.

Kauj ruam 5

Pom thawj cov ntawv thov txawv teb hauv cov qauv qhib cov ntawv qhib, uas tau tsim los ntawm txhaj rau "khawm" khawm. Txhawm rau pom thiab xaiv nws, nyem "Qhib" khawm.

Kauj Ruam 6

Hloov cov encoding uas tau hais tseg hauv Cov Ntaub Ntawv encoding teb yog tias nws txawv ntawm qhov siv thaum txuag cov ntaub ntawv txawv teb. Qhov no tsuas yog tsim nyog yog tias muaj cov ntawv sau hauv cov kab ntawv uas muaj cov ntawv sau tsis yog lus Askiv.

Kauj Ruam 7

Nyem lub pob "OK" nyob rau hauv qab kawg ntawm sab xis txoj cai ntawm phpMyAdmin interface thiab daim ntawv thov yuav pib xa cov ntaub ntawv txawv teb mus rau server SQL nqe lus.

Kauj ruam 8

Rov ua qhov kawg peb kauj ruam dhau los ntau zaus raws li qhov tsim nyog yog tias koj muaj ntau tshaj ib qho cov ntaub ntawv qhia.

Kauj Ruam 9

Yog tias qhov txawv teb database yog me me, ces koj tuaj yeem ua yam tsis rub cov ntawv. Muaj plaub lub xwm fab xwm txheej nyob sab saum toj ntawm kab laug sab xis - nyem tus thib ob los ntawm sab laug ("Lus Nug Qhov rai"). Lub qhov rais me me yuav qhib qhov twg koj tuaj yeem muab cov hlua ntawm cov lus nug SQL los ntawm kev luam lawv los ntawm cov ntaub ntawv "database". Tom qab ntawd nyem khawm "OK" thiab cov lus qhia yuav muab xa mus rau tus neeg rau zaub mov.

Pom zoo: