Kev Qhia Txog Kev Tsim MySQL Database Los Ntawm Kos
MySQL yog ib qho ntawm cov txheej txheem tswj hwm database (RDBMS) nrov tshaj plaws hauv ntiaj teb. Nws paub txog nws qhov ceev, kev ntseeg siab, thiab yooj yim siv. Hauv tsab xov xwm no, peb yuav tham txog cov kauj ruam rau kev tsim ib lub database MySQL txij thaum pib, suav nrog kev teeb tsa, kev sib txuas, kev tsim cov rooj, thiab kev tswj cov ntaub ntawv.
1. Kev Teeb tsa MySQL
Kauj Ruam 1: Rub Tawm MySQL
Ua ntej, koj yuav tsum rub tawm MySQL. Mus saib lub vev xaib MySQL (https://dev.mysql.com/downloads/) thiab xaiv qhov version ntawm MySQL uas phim koj lub operating system. Xyuas kom tseeb tias koj rub tawm qhov Community version pub dawb.
Kauj Ruam 2: Nruab MySQL
Tom qab rub tawm, ua raws li cov kauj ruam teeb tsa raws li cov lus qhia tau muab. Cov txheej txheem teeb tsa feem ntau suav nrog:
– Pom zoo rau cov nqe lus thiab tej yam kev mob.
- Xaiv cov khoom uas yuav tsum tau teeb tsa (Server, Workbench, thiab lwm yam).
- Teeb tsa cov chaw teeb tsa ntawm lub server (chaw nres nkoj, tus password hauv paus, thiab lwm yam).
- Pib qhov kev pabcuam MySQL.
Koj tuaj yeem xaiv qhov chaw teeb tsa ua ntej, tab sis tsis txhob hnov qab sau cia tus password hauv paus.
2. Siv MySQL Workbench
MySQL Workbench yog ib lub cuab yeej GUI uas ua rau kev tswj hwm database yooj yim dua. Cov lus qhia hauv qab no yuav siv MySQL Workbench, tab sis koj kuj tuaj yeem siv kab hais kom ua.
Kauj Ruam 1: Qhib MySQL Workbench
Qhib MySQL Workbench thiab tsim ib qho kev sib txuas tshiab. Sau lub npe kev sib txuas thiab cov ntaub ntawv ntawm lub server (feem ntau yog `localhost` lossis `127.0.0.1`), nrog rau lo lus zais hauv paus uas koj tau tsim thaum lub sijhawm teeb tsa.
Kauj Ruam 2: Tsim Ib Lub Database Tshiab
Nyem sab xis rau ntawm `Schemas` nyob rau hauv lub vaj huam sib luag sab laug thiab xaiv `Tsim Schema`. Sau koj lub npe database xav tau, piv txwv li `db_tutorial`.
"`sql
TSIM COV NTAUB NTAWV db_tutorial;
“
3. Tsim ib lub Rooj
Tam sim no peb yuav tsim ib lub rooj hauv lub database `db_tutorial`.
Kauj Ruam 1: Xaiv Cov Ntaub Ntawv
Yog tias siv kab hais kom ua:
"`sql
SIV db_tutorial;
“
Yog tias siv MySQL Workbench, ob npaug nias rau ntawm `db_tutorial` hauv lub vaj huam sib luag schema.
Kauj Ruam 2: Tsim Ib Lub Rooj
Nov yog ib qho piv txwv ntawm SQL script los tsim ib lub rooj `users`:
"`sql
TSIM COV NEEG SIV LUB ROOJ (
id INT AUTO_INCREMENT TUS KEY PRIMARY,
lub npe neeg siv VARCHAR (50) TSIS MUAJ NULL,
email VARCHAR (100) TSIS MUAJ NULL,
tsim_thaum TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
“
Kev Piav Qhia:
– `id`: Ua tus yuam sij tseem ceeb nrog kev nce qib tsis siv neeg.
– `username`: Kab ntawv los khaws lub npe neeg siv.
– `email`: Kem rau khaws cov email ntawm tus neeg siv.
– `created_at`: Kab ntawv khaws lub sijhawm thaum cov ntaub ntawv tau tsim.
4. Sau Cov Ntaub Ntawv
Kauj Ruam 1: Ntxiv Cov Ntaub Ntawv
Peb yuav siv cov lus txib `INSERT INTO` los ntxig cov ntaub ntawv rau hauv lub rooj `users`.
"`sql
NTXAWV INTO rau cov neeg siv (lub npe neeg siv, email) VALUES ('john_doe', '[email tiv thaiv]');
NTXAWV INTO cov neeg siv (lub npe neeg siv, email) VALUES ('jane_doe', '[email tiv thaiv]');
“
Kauj Ruam 2: Txheeb Xyuas Cov Ntaub Ntawv
Yuav kom paub tseeb tias cov ntaub ntawv tau raug ntaus, koj tuaj yeem siv cov lus txib `SELECT`.
"`sql
XAIV LOS NTAWM cov neeg siv;
“
5. Kev Tswj Xyuas Cov Ntaub Ntawv
Kauj Ruam 1: Hloov Kho Cov Ntaub Ntawv
Txhawm rau hloov kho cov ntaub ntawv hauv lub rooj `users`, koj tuaj yeem siv cov lus txib `UPDATE`:
"`sql
UPDATE cov neeg siv SET email = '[email tiv thaiv]' QHOV TWG lub npe neeg siv = 'john_doe';
“
Kauj Ruam 2: Rho Tawm Cov Ntaub Ntawv
Yog xav rho tawm cov ntaub ntawv ntawm lub rooj, siv cov lus txib 'DELETE':
"`sql
RHO TAWM LOS NTAWM cov neeg siv qhov twg lub npe neeg siv = 'john_doe';
“
6. Thaub qab thiab rov qab los
Kev thaub qab ntawm cov ntaub ntawv
Yuav kom thaub qab ib lub database, koj siv tau cov lus txib `mysqldump` ntawm kab hais kom ua:
"`sh
mysqldump -u root -p db_tutorial > db_tutorial_backup.sql
“
Cov lus txib no yuav tsim ib daim ntawv `db_tutorial_backup.sql` uas muaj tag nrho cov ntaub ntawv thiab cov qauv ntawm lub ntaub ntawv `db_tutorial`.
Rov qab kho cov ntaub ntawv hauv paus
Yuav kom rov qab tau ib lub database los ntawm cov ntaub ntawv thaub qab, siv cov lus txib hauv qab no:
"`sh
mysql -u root -p db_tutorial < db_tutorial_backup.sql ``` 7. Siv PHP los txuas rau MySQL
tuag(“Kev sib txuas tsis ua tiav: ” . $conn->connect_error);
}
echo “Txuas tau zoo lawm”;
?>
“
Hloov 'password' nrog koj tus password hauv paus.
Kauj Ruam 2: Nkag mus rau hauv browser
Qhib cov ntaub ntawv `connect.php` hauv koj tus browser. Yog tias kev sib txuas ua tiav, koj yuav pom cov lus "Connected successfully."
8. Cov Kev Xyaum Zoo Tshaj Plaws hauv Kev Tswj Xyuas Database
- Siv Cov Ntawv Qhia: Cov Ntawv Qhia tuaj yeem ua kom qee qhov kev ua haujlwm SELECT, INSERT, UPDATE, thiab DELETE sai dua.
- Kev Ua Kom Zoo: Txo cov ntaub ntawv rov ua dua thiab xyuas kom meej tias cov ntaub ntawv sib xws.
- Kev thaub qab tsis tu ncua: Ib txwm ua cov thaub qab tsis tu ncua ntawm koj lub ntaub ntawv kom tsis txhob poob cov ntaub ntawv.
- Kev Ruaj Ntseg: Nco ntsoov siv cov txheej txheem lees paub zoo thiab txwv kev nkag mus rau hauv lub database.
Xaus
Hauv zaj lus qhia no, peb tau tham txog cov kauj ruam yooj yim rau kev teeb tsa MySQL, tsim cov ntaub ntawv thiab cov lus qhia, thiab ntxig thiab tswj cov ntaub ntawv. Qhov no muab lub hauv paus ruaj khov rau kev pib ua haujlwm nrog MySQL hauv koj cov haujlwm. Nco ntsoov ua raws li cov kev coj ua zoo tshaj plaws ntawm kev tswj hwm cov ntaub ntawv kom ntseeg tau tias muaj kev ua tau zoo tshaj plaws thiab kev ruaj ntseg. Peb vam tias tsab xov xwm no yuav pab tau, thiab thov kom koj muaj hmoo!
