Ib txoj hauv kev yooj yim raws cov ntawv hu ua mysql yuav tsum yog ib feem ntawm koj kev teeb tsa MySQL. Nws cia koj xa SQL cov lus nug ncaj qha rau MySQL server thiab tso tawm cov txiaj ntsig hauv hom ntawv. Nws yog txoj hauv kev nrawm thiab yooj yim los sim koj li kev teeb tsa MySQL.
Cov kauj ruam
Kauj Ruam 1. Nrhiav qhov program mysql (Yuav tsum yog nyob rau hauv subdirectory hu ua bin hauv qab cov npe uas MySQL tau teeb tsa)
- Piv txwv li Cov neeg siv Windows: C: / mysql / bin / mysql.exe
- Piv txwv li Linux/Unix cov neeg siv: /usr/zos/mysql/bin/mysql
Kauj Ruam 2. Pib mysql - Ntawm qhov hais kom sai, ntaus:
mysql -h hostname -u username -p,
-
qhov twg
- tus tswv yog lub tshuab uas MySQL server tab tom khiav
- username yog MySQL tus account koj xav siv
- -p yuav ua rau mysql sai rau koj rau MySQL tus lej password.
Kauj Ruam 3. Nkag mus rau koj tus password thaum hais kom sai
Kauj Ruam 4. Ntaus koj cov lus txib SQL ua raws cov kab lus ib nrab (;) thiab nias Enter
Cov lus teb los ntawm tus neeg rau zaub mov yuav tsum tshwm ntawm koj lub vijtsam.
Kauj Ruam 5. Txhawm rau tawm ntawm mysql, ntaus tawm ntawm qhov hais kom sai thiab nyem Enter
Txoj Kev 1 ntawm 1: Khiav yam tsis muaj lub console
Kauj Ruam 1. Nrhiav qhov program mysql (Yuav tsum yog nyob rau hauv subdirectory hu ua bin hauv qab cov npe uas MySQL tau teeb tsa)
- Piv txwv li Cov neeg siv Windows: C: / mysql / bin / mysql.exe
- Piv txwv li Linux/Unix cov neeg siv: /usr/zos/mysql/bin/mysql
Kauj Ruam 2. Pib mysql - Ntawm qhov hais kom sai, ntaus:
mysql -h hostname -u username -p db_name -e "lus nug"
-
qhov twg
- tus tswv yog lub tshuab uas MySQL server tab tom khiav
- username yog MySQL tus account koj xav siv
- -p yuav ua rau mysql sai rau koj rau MySQL tus lej password.
- db_name yog lub npe ntawm cov database los khiav cov lus nug hauv, thiab,
- lus nug yog cov lus nug uas koj xav khiav.
Kauj Ruam 3. Nkag mus rau koj tus password thaum hais kom sai
Kauj Ruam 4. MySQL yuav tsum xa qhov tshwm sim ntawm koj cov lus nug
Lub tswv yim
- Nco ntsoov suav nrog; qhov kawg ntawm koj cov lus nug yog tias koj siv lub console yog li nws paub tias koj tau ua tiav nrog cov lus nug.
- Koj tuaj yeem hais qhia tus password rau kab hais kom ua los ntawm muab nws ncaj qha tom qab -p, piv txwv li mysql -u username -h host -p lo lus zais. Daim ntawv ceeb toom tsis muaj chaw nyob ntawm -p thiab tus password.
- Yog tias koj tab tom khiav nws los ntawm kab hais kom ua thiab tsis siv lub plhaub, koj tuaj yeem siv -B tus chij (piv txwv li, mysql -u username '-h host -p db_name -Be "query") kom tau txais cov zis hauv hom ua haujlwm, hloov chaw ntawm MySQL tabular hom, rau kev ua ntxiv.