Kab lus no yuav 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 lej tshwj xeeb rau kev hloov kho cov ntsiab lus ntawm cov ntaub ntawv txheeb ze thiab cov qauv txheej txheem. Lawv tuaj yeem qhib siv MySQL Workbench yog tias koj xav siv MySQL cov cuab yeej rau kev txhim kho, kev tswj hwm, tsim qauv thiab lwm yam kev tswj hwm hauv koj li database. Yog tias koj tsuas xav pom thiab hloov kho tus lej sai, siv cov ntawv yooj yim xws li "Notepad" lossis "TextEdit".
cov kauj ruam
Txoj Kev 1 ntawm 2: Siv MySQL Workbench
Kauj Ruam 1. Qhib MySQL Workbench ntawm koj lub computer
Nws muaj lub cim ntses taub ntswg ntev hauv lub xwmfab xiav. Koj tuaj yeem pom nws hauv "Start" menu (Windows) lossis hauv "Applications" folder (Mac).
Yog tias koj tsis muaj MySQL Workbench teeb tsa, rub nws rau koj lub operating system los ntawm
Kauj Ruam 2. Nyem ob npaug ntawm tus qauv lossis cov ntaub ntawv hauv qab "MySQL Txuas"
Koj yuav pom koj tus qauv piv txwv muaj nyob ntawm qhov chaw no. Tsuas yog ob npaug nyem rau ntawm qhov koj xav siv.
Kauj Ruam 3. Nyem rau ntawm File tab nyob rau sab saud sab laug ntawm qhov screen
Tom qab ntawv cov ntawv qhia zaub mov qhib yuav qhib.
Kauj Ruam 4. Nyem Qhib SQL Script hauv "File" menu
Ua li ntawd yuav qhib qhov tshiab "File Explorer" qhov rai rau koj mus rau qhov xav tau cov ntaub ntawv SQL.
Koj tseem tuaj yeem nias Ctrl+⇧ Shift+O (Windows) lossis ⌘ Cmd+⇧ Shift+O (Mac)
Kauj Ruam 5. Nrhiav SQL cov ntaub ntawv koj xav qhib
Ua qhov no siv lub qhov rai browser thiab nyem rau ntawm lub npe kom xaiv cov ntawv.
Kauj Ruam 6. Nyem Qhib nyob rau hauv kaum sab xis ntawm lub browser browser
Tom qab ntawd cov ntsiab lus ntawm SQL cov ntaub ntawv hauv MySQL Workbench.
Tam sim no koj tuaj yeem pom thiab kho koj tsab ntawv SQL
Txoj Kev 2 ntawm 2: Siv Tus Sau Cov Ntawv
Kauj Ruam 1. Nrhiav cov ntaub ntawv SQL thiab nyem rau nws
Ua li ntawd yuav coj los rau hauv cov ntawv qhia zaub mov nco ntawm kev xaiv.
Kauj Ruam 2. Nas Tshaj Qhib Nrog hauv cov ntawv qhia zaub mov
Tom qab ntawd cov npe ntawm cov ntawv thov pom zoo rau qhib cov ntawv no yuav tshwm.
Kauj Ruam 3. Xaiv Notepad (Windows) lub TextEdit (Mac).
Ua li ntawd yuav qhib cov ntaub ntawv SQL hauv cov ntawv nyeem xaiv. Tam sim no koj tuaj yeem pom thiab kho SQL tsab ntawv tus kheej.
- Yog tias koj tsis pom "Notepad" lossis "TextEdit", nyem rau Xaiv lwm lub app los yog Lwm yam hauv qab. Ua li ntawd yuav qhib daim ntawv teev npe nrog txhua daim ntawv thov teeb tsa ntawm koj lub cuab yeej.
