Qhov wikiHow no qhia koj li cas qhib thiab saib cov ntsiab lus ntawm SQL (Structured Query Language) cov ntaub ntawv cov ntaub ntawv. SQL cov ntaub ntawv muaj cov cai tshwj xeeb los hloov pauv cov ntsiab lus ntawm cov ntaub ntawv txheeb ze thiab cov qauv txheej txheem. Koj tuaj yeem qhib SQL cov ntaub ntawv hauv MySQL Workbench yog tias koj xav siv MySQL cov cuab yeej rau koj cov ntaub ntawv txhim kho, kev tswj hwm, tsim qauv, thiab lwm yam haujlwm saib xyuas. Yog tias koj tsuas xav pom thiab hloov kho koj tus lej sai, koj tuaj yeem siv cov ntawv sau yooj yim xws li Notepad lossis TextEdit.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Siv MySQL Workbench
Kauj Ruam 1. Qhib MySQL Workbench app hauv koj lub computer
MySQL Workbench icon zoo li ntses taub ntswg ntev hauv lub xwmfab xiav. Koj tuaj yeem pom nws ntawm koj cov ntawv qhia zaub mov Pib ntawm Windows lossis hauv daim nplaub tshev daim ntawv thov ntawm Mac.
Yog tias koj tsis muaj MySQL Workbench teeb tsa hauv koj lub computer, koj tuaj yeem xaiv koj li kab ke, thiab rub tawm lub installer app ntawm
Kauj Ruam 2. Ob-nias tus qauv lossis cov ntaub ntawv hauv qab "MySQL Kev Sib Txuas
" Koj yuav pom koj cov qauv piv txwv muaj nyob ntawm no. Tsuas yog ob npaug nias qhov koj xav siv.
Kauj Ruam 3. Nyem Cov Ntaub Ntawv tab nyob rau sab saud
Lub pob no yog nyob rau sab saud sab laug ntawm koj lub vijtsam. Nws yuav qhib cov ntawv qhia zaub mov nco-down.
Kauj Ruam 4. Nyem Qhib SQL Script ntawm File menu
Qhov no yuav qhib lub qhov rai tshiab cov ntawv qhia chaw, thiab tso cai rau koj xaiv SQL cov ntaub ntawv koj xav qhib.
Xwb, nias Ctrl+⇧ Shift+O (Windows) lossis ⌘ Cmd+⇧ Shift+O (Mac) ntawm koj cov keyboard
Kauj Ruam 5. Nrhiav thiab nyem SQL cov ntaub ntawv koj xav qhib
Siv cov ntaub ntawv navigator qhov rai kom pom koj cov ntaub ntawv SQL, thiab nyem rau ntawm nws lub npe los xaiv cov ntawv.
Kauj Ruam 6. Nyem Qhib rau hauv qab-sab xis
Lub pob no yog nyob rau sab qis-sab xis ntawm cov ntaub ntawv navigator pop-up. Nws yuav qhib koj cov ntaub ntawv SQL cov ntsiab lus hauv MySQL Workbench app.
Koj tuaj yeem saib thiab kho koj tsab ntawv SQL ntawm no
Txoj Kev 2 ntawm 2: Siv Tus Sau Cov Ntawv
Kauj Ruam 1. Nrhiav thiab nyem rau ntawm SQL cov ntaub ntawv
Qhov no yuav qhib koj txoj cai-nyem xaiv ntawm cov ntawv qhia zaub mov nco-down.
Kauj ruam 2. Hover dua Qhib nrog rau ntawm txoj cai-nias cov ntawv qhia zaub mov
Qhov no yuav qhib cov npe ntawm cov ntawv thov pom zoo kom qhib cov ntawv no.
Kauj Ruam 3. Xaiv Notepad (Windows) lub TextEdit (Mac).
Qhov no yuav qhib koj cov ntaub ntawv SQL hauv koj cov ntawv sau. Koj tuaj yeem yooj yim saib thiab kho tus kheej SQL tsab ntawv hauv cov ntawv sau ntawm no.