Yuav Ua Li Cas Qhib SQL Cov Ntaub Ntawv: 9 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav Ua Li Cas Qhib SQL Cov Ntaub Ntawv: 9 Kauj Ruam (nrog Duab)
Yuav Ua Li Cas Qhib SQL Cov Ntaub Ntawv: 9 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Qhib SQL Cov Ntaub Ntawv: 9 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Qhib SQL Cov Ntaub Ntawv: 9 Kauj Ruam (nrog Duab)
Video: 5 Yam: Txhob pub muaj nyob hauv Tsev (Tsis Zoo) 2024, Kaum ib hlis
Anonim

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

Qhib Sql Cov Ntaub Ntawv Kauj Ruam 1
Qhib Sql Cov Ntaub Ntawv Kauj Ruam 1

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

Qhib Sql File Step 2
Qhib Sql File Step 2

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.

Qhib Sql Cov Ntaub Ntawv Kauj Ruam 3
Qhib Sql Cov Ntaub Ntawv Kauj Ruam 3

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.

Qhib Sql Cov Ntaub Ntawv Kauj Ruam 4
Qhib Sql Cov Ntaub Ntawv Kauj Ruam 4

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

Qhib Sql File Step 5
Qhib Sql File Step 5

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.

Qhib Sql Cov Ntaub Ntawv Kauj Ruam 6
Qhib Sql Cov Ntaub Ntawv Kauj Ruam 6

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

Qhib Sql File Step 7
Qhib Sql File Step 7

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.

Qhib Sql Cov Ntaub Ntawv Kauj Ruam 8
Qhib Sql Cov Ntaub Ntawv Kauj Ruam 8

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.

Qhib Sql Cov Ntaub Ntawv Kauj Ruam 9
Qhib Sql Cov Ntaub Ntawv Kauj Ruam 9

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.

Yog tias koj tsis pom Notepad lossis TextEdit hauv cov ntawv qhia zaub mov, nyem " Xaiv lwm lub app "los yog" Lwm yam "Hauv qab ntawm cov ntawv qhia zaub mov. Ib daim ntawv teev tag nrho cov apps tau teeb tsa yuav tshwm tom qab ntawd.

Pom zoo: