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 txhawm rau hloov pauv cov ntaub ntawv txheeb ze txheeb ze thiab qauv qauv. Koj tuaj yeem qhib SQL cov ntaub ntawv hauv MySQL Workbench yog tias koj xav siv MySQL cov cuab yeej rau kev txhim kho database, kev tswj hwm, tsim qauv, thiab lwm yam haujlwm saib xyuas. Yog tias koj tsuas yog xav tau nrawm saib thiab hloov kho tus lej, siv cov ntawv yooj yim kho qhov program zoo li Notepad lossis TextEdit.
Kauj ruam
Txoj Kev 1 ntawm 2: Siv MySQL Workbench
Kauj Ruam 1. Qhib MySQL Workbench program hauv computer
MySQL Workbench icon zoo li tus ntses taub ntswg ntev hauv lub duab plaub xiav. Koj tuaj yeem pom nws hauv "Pib" ntawv qhia zaub mov ntawm lub khoos phis tawj Windows lossis hauv "Cov Ntawv Thov" nplaub tshev ntawm Mac.
Yog tias koj tsis muaj MySQL Workbench teeb tsa hauv koj lub khoos phis tawj, xaiv qhov tsim nyog ua haujlwm thiab rub tawm cov program teeb tsa ntawm
Kauj Ruam 2. Ob npaug nias tus qauv lossis cov ntaub ntawv hauv qab "MySQL Connections" ntu
Koj tuaj yeem pom cov qauv kev xaiv muaj nyob hauv ntu no. Tsuas yog ob npaug nias tus qauv koj xav siv.
Kauj Ruam 3. Nyem Cov Ntaub Ntawv tab nyob rau ntawm kaum sab laug saum toj ntawm lub vijtsam
Nws nyob rau sab saud sab laug ntawm lub vijtsam lossis lub qhov rai program. Cov ntawv qhia zaub mov nco-down yuav qhib tom qab.
Kauj Ruam 4. Nyem Qhib SQL Script ntawm "File" menu
Lub qhov rai tshiab qhib cov ntaub ntawv yuav qhib thiab koj tuaj yeem xaiv SQL cov ntaub ntawv uas xav tau qhib.
Xwb, nyem qhov shortcut Ctrl+⇧ Shift+O (Windows) lossis Cmd+⇧ Shift+O (Mac) ntawm koj cov keyboard
Kauj Ruam 5. Nrhiav thiab nyem SQL cov ntaub ntawv uas koj xav qhib
Siv lub qhov rai qhia tshawb nrhiav cov ntawv, tom qab ntawd nyem nws lub npe kom xaiv nws.
Kauj Ruam 6. Nyem Qhib nyob rau hauv kaum sab xis ntawm lub qhov rais
Nws nyob hauv kaum sab xis-sab xis ntawm cov ntawv qhia pop-up qhov rai. Cov ntsiab lus ntawm SQL cov ntawv yuav raug nthuav tawm hauv MySQL Workbench qhov rai.
Koj tuaj yeem tshuaj xyuas thiab kho cov cai SQL los ntawm txoj haujlwm tom qab
Txoj Kev 2 ntawm 2: Siv Txoj Cai Kho Kom Zoo Nkauj
Kauj Ruam 1. Nrhiav thiab nyem rau ntawm SQL cov ntaub ntawv
Txoj cai-nias xaiv yuav tshwm nyob rau hauv cov ntawv qhia zaub mov nco-down.
Kauj Ruam 2. Hover dua Qhib nrog nyob rau hauv txoj cai-nias cov ntawv qhia zaub mov
Cov npe ntawm cov ntawv thov kom qhib cov ntawv xaiv yuav raug nthuav tawm.
Kauj Ruam 3. Xaiv Notepad (Windows) lub TextEdit (Mac).
Cov ntaub ntawv SQL yuav qhib rau hauv kab ntawv kho kab ntawv. Tam sim no koj tuaj yeem tshuaj xyuas tau yooj yim thiab hloov kho SQL code tus kheej los ntawm kab ntawv kho qhov program.
