Dzidziso pakugadzira MySQL Database kubva paScratch
MySQL ndeimwe yemasystem ekutarisira database ane mukurumbira pasi rose (RDBMS). Inozivikanwa nekumhanya kwayo, kuvimbika, uye nyore kushandisa. Muchinyorwa chino, tichakurukura matanho ekugadzira database yeMySQL kubva pakutanga, kusanganisira kuisa, kubatana, kugadzira tafura, uye kugadzirisa data.
1. Kuiswa kweMySQL
Danho 1: Dhawunirodha MySQL
Kutanga, unofanira kudhawunirodha MySQL. Enda pawebhusaiti yepamutemo yeMySQL (https://dev.mysql.com/downloads/) wosarudza vhezheni yeMySQL inoenderana nesystem yako yekushandisa. Ita shuwa kuti wadhawunirodha vhezheni yeCommunity yemahara.
Danho rechipiri: Isa MySQL
Mushure mekudhawunirodha, tevera matanho ekuisa zvichienderana nemirairo yakapihwa. Maitiro ekuisa anowanzo sanganisira:
- Bvumiranai nemitemo nemamiriro ezvinhu.
– Sarudza zvinhu zvinofanirwa kuiswa (Server, Workbench, nezvimwewo).
- Gadza marongero eseva (port, root password, nezvimwewo).
- Kutanga sevhisi yeMySQL.
Unogona kusarudza marongero awakaisa pakutanga, asi usakanganwa kunyora pasi password yemudzi.
2. Kushandisa MySQL Workbench
MySQL Workbench chishandiso cheGUI chinoita kuti manejimendi yedatabase ive nyore. Mirayiridzo inotevera ichashandisa MySQL Workbench, asi unogona zvakare kushandisa mutsetse wemirairo.
Danho 1: Vhura MySQL Workbench
Vhura MySQL Workbench wogadzira chinongedzo chitsva. Isa zita rechinongedzo uye ruzivo rwesevha (kazhinji `localhost` kana `127.0.0.1`), pamwe chete nepassword yemudzi yawakagadzira panguva yekuisa.
Danho rechipiri: Kugadzira Dhatabhesi Idzva
Dzvanya kurudyi pa `Schemas` kuruboshwe wobva wasarudza `Create Schema`. Isa zita re database raunoda, semuenzaniso `db_tutorial`.
"sql"
Gadzira Dhatabhesi db_tutorial;
``
3. Gadzira Tafura
Iye zvino tichagadzira tafura mudhatabhesi re `db_tutorial`.
Danho 1: Sarudza Dhatabhesi
Kana uchishandisa mutsetse wekuraira:
"sql"
SHANDISA db_tutorial;
``
Kana uchishandisa MySQL Workbench, tinya kaviri pa `db_tutorial` mupaneru yeschemas.
Danho rechipiri: Kugadzira Tafura
Heino muenzaniso weSQL script yekugadzira tafura ye `users`:
"sql"
Gadzira vashandisi veTABHURE (
id INT AUTO_INCREMENT PRIMARY KEY,
zita rekushandisa VARCHAR(50) HAPANA KUSHANDISWA,
email VARCHAR(100) HAISI ZVINHU ZVOSE,
yakagadzirwa_paTIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
``
Tsanangudzo:
– `id`: Sekiyi huru ine auto-increment.
– `username`: Koramu yekuchengetedza zita remushandisi.
– `email`: Koramu yekuchengetedza email yemushandisi.
– `yakagadzirwa_pa`: Koramu yekuchengetedza nguva apo chinyorwa chakagadzirwa.
4. Kuisa Data
Danho 1: Kuwedzera Data
Tichashandisa murairo wekuti `INSERT INTO` kuisa data mutafura ye`users`.
"sql"
Isa muvashandisi (zita rekushandisa, email) ZVINHU ('john_doe', '[email inodzivirirwa]');
ISA MUVASHANDISI (zita rekushandisa, email) ZVINHU ('jane_doe', '[email inodzivirirwa]');
``
Danho rechipiri: Simbisa Ruzivo
Kuti uve nechokwadi chekuti data rapinda, unogona kushandisa murairo wekuti `SELECT`.
"sql"
SARUDZA KUBVA KUVASHANDISI;
``
5. Kutarisira Data
Danho 1: Kugadzirisa Data
Kuti ugadzirise data riri mutafura ye`vashandisi`, unogona kushandisa murairo we`UPDATE`:
"sql"
Gadzirisa vashandisi SET email = '[email inodzivirirwa]'KUPI zita rekushandisa = 'john_doe';'
``
Danho rechipiri: Kubvisa Data
Kuti ubvise data kubva patafura, shandisa murairo wekuti `DELETE`:
"sql"
DZIMA KUBVA KUVASHANDISI PAKUTI zita rekushandisa = 'john_doe';
``
6. Backup uye Dzorera
Kuchengetedza Database
Kuti uchengetedze database, unogona kushandisa murairo wekuti `mysqldump` uri pamutsetse wemirairo:
“`sh
mysqldump -u root -p db_tutorial > db_tutorial_backup.sql
``
Murairo uyu uchagadzira faira re `db_tutorial_backup.sql` rine data rese uye chimiro chedhatabhesi re `db_tutorial`.
Dzorera Dhatabhesi
Nekuti dzorera dhatabhesi kubva kufaira rekuchengetedza, shandisa murairo unotevera:
“`sh
mysql -u root -p db_tutorial <db_tutorial_backup.sql
``
7. Kushandisa PHP kubatanidza kuMySQL
Kuti ugadzire mawebhusaiti ane simba , unowanzo batanidza MySQL nemutauro wepurogiramu wakaita sePHP. Heino muenzaniso wekutanga:
Danho rekutanga: Kodhi Yokunyora Connection
Gadzira faira idzva rinonzi `connect.php` wobva wawedzera kodhi inotevera:
"`php
kufa ("Kubatana kwakundikana:". $conn->connect_error);
}
echo "Yakabatana zvinobudirira";
?>
``
Tsiva `password` nepassword yako yemidzi.
Danho rechipiri: Kupinda kuburikidza neBrowser
Vhura faira rekuti `connect.php` mubrowser yako. Kana connection yacho ikabudirira, uchaona meseji inoti “Connected successfully.”
8. Maitiro Akanakisisa Mukutarisira Dhatabhesi
- Kushandisa maIndex: maIndex anogona kukurumidzisa mamwe mabasa eSELECT, INSERT, UPDATE, uye DELETE.
- Kugadzirisa zvinhu: Kuderedza kudzokororwa kwedata uye kuona kuti data rinogara richishanda zvakanaka.
- Kuchengetedza data nguva dzose: Gara uchichengetedza data nguva dzose kuti data risarasikirwe.
- Kuchengetedzwa: Iva nechokwadi chekushandisa nzira dzakasimba dzekusimbisa uye kudzora mukana wekupinda mudhatabhesi.
Mhedziso
Muchidzidzo chino, takurukura matanho ekutanga ekuisa MySQL, kugadzira madhatabhesi nematafura, uye kuisa nekugadzirisa data. Izvi zvinopa hwaro hwakasimba hwekutanga kushanda neMySQL mumapurojekiti ako. Gara uchiyeuka kutevedzera nzira dzakanakisisa dzekutarisira database kuti uve nechokwadi chekuti inoshanda zvakanaka uye yakachengeteka. Tinovimba kuti chinyorwa ichi chakabatsira, uye rombo rakanaka!
