Isifundo Sokudala Idathabheyisi ye-MySQL Kusukela Ekuqaleni
I-MySQL ingenye yezinhlelo zokuphathwa kwedatha yokuxhumana ezidumile kakhulu (i-RDBMS) emhlabeni. Yaziwa ngesivinini sayo, ukuthembeka kwayo, kanye nokulula kwayo ukuyisebenzisa. Kulesi sihloko, sizoxoxa ngezinyathelo zokudala idatha yolwazi ye-MySQL kusukela ekuqaleni, okuhlanganisa ukufakwa, ukuxhumana, ukudalwa kwetafula, kanye nokuphathwa kwedatha.
1. Ukufakwa kwe-MySQL
Isinyathelo 1: Landa i-MySQL
Okokuqala, udinga ukulanda i-MySQL. Vakashela iwebhusayithi esemthethweni ye-MySQL (https://dev.mysql.com/downloads/) bese ukhetha inguqulo ye-MySQL ehambisana nesistimu yakho yokusebenza. Qiniseka ukuthi ulanda inguqulo yamahhala yomphakathi.
Isinyathelo 2: Faka i-MySQL
Ngemva kokulanda, landela izinyathelo zokufaka ngokwemiyalelo enikeziwe. Inqubo yokufaka ivame ukufaka:
– Vuma ngemigomo nemibandela.
– Khetha izingxenye ezizofakwa (i-Server, i-Workbench, njll.).
– Setha izilungiselelo zeseva (i-port, iphasiwedi yempande, njll.).
- Ukuqala isevisi ye-MySQL.
Ungakhetha izilungiselelo ezizenzakalelayo, kodwa ungakhohlwa ukubhala phansi iphasiwedi yempande.
2. Ukusebenzisa i-MySQL Workbench
I-MySQL Workbench iyithuluzi le-GUI elenza ukuphathwa kwedatha kube lula. Imiyalelo elandelayo izosebenzisa i-MySQL Workbench, kodwa ungasebenzisa nomugqa womyalo.
Isinyathelo 1: Vula i-MySQL Workbench
Vula i-MySQL Workbench bese udala uxhumano olusha. Faka igama loxhumano kanye nemininingwane yeseva (ngokuvamile `localhost` noma `127.0.0.1`), kanye nephasiwedi yempande oyidalile ngesikhathi sokufakwa.
Isinyathelo 2: Ukudala Idathabheyisi Entsha
Chofoza ngakwesokudla ku-'Schemas' kuphaneli yesobunxele bese ukhetha okuthi 'Dala i-Schema'. Faka igama lesizindalwazi olifunayo, isibonelo 'db_tutorial'.
"sql
DALA IDATHA YEZINDABA db_tutorial;
``
3. Dala Ithebula
Manje sizokwakha ithebula kusizindalwazi se-`db_tutorial`.
Isinyathelo 1: Khetha i-Database
Uma usebenzisa umugqa womyalo:
"sql
SEBENZISA i-db_tutorial;
``
Uma usebenzisa i-MySQL Workbench, chofoza kabili ku-`db_tutorial` kuphaneli ye-schemas.
Isinyathelo 2: Ukudala Ithebula
Nasi isibonelo sesikripthi se-SQL sokudala ithebula elithi `abasebenzisi`:
"sql
DALA abasebenzisi be-TABLE (
id INT AUTO_INCREMENT PRIMARY KEY,
igama lomsebenzisi i-VARCHAR(50) AKUSIYO NULL,
i-imeyili i-VARCHAR(100) AKUSIYO NULL,
dalwe_ku-TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
``
Incazelo:
– `id`: Njengesihluthulelo esiyinhloko esinokukhushulwa okuzenzakalelayo.
– `igama lomsebenzisi`: Ikholomu yokugcina igama lomsebenzisi.
– `i-imeyili`: Ikholomu yokugcina i-imeyili yomsebenzisi.
– `kudaliwe_ku`: Ikholomu yokugcina isitembu sesikhathi lapho okufakiwe kudalwe khona.
4. Ukufaka Idatha
Isinyathelo 1: Ukwengeza Idatha
Sizosebenzisa umyalo othi `INSERT INTO` ukufaka idatha kuthebula elithi `users`.
"sql
FAKA KUbasebenzisi (igama lomsebenzisi, i-imeyili) AMANINGI ('john_doe', '[i-imeyili ivikelwe]');
FAKA KUbasebenzisi (igama lomsebenzisi, i-imeyili) AMANINGI ('jane_doe', '[i-imeyili ivikelwe]');
``
Isinyathelo 2: Qinisekisa Idatha
Ukuqinisekisa ukuthi idatha ifakiwe, ungasebenzisa umyalo othi `SELECT`.
"sql
KHETHA KUBASEBENZISI;
``
5. Ukuphatha Idatha
Isinyathelo 1: Ukubuyekeza Idatha
Ukuze ubuyekeze idatha kuthebula elithi `abasebenzisi`, ungasebenzisa umyalo othi `UPDATE`:
"sql
BUYEKEZA abasebenzisi SETHA i-imeyili = '[i-imeyili ivikelwe]'LAPHO igama lomsebenzisi = 'john_doe';
``
Isinyathelo 2: Ukususa Idatha
Ukuze ususe idatha etafuleni, sebenzisa umyalo othi `DELETE`:
"sql
SUSA KUBASEBENZISI LAPHO igama lomsebenzisi = 'john_doe';
``
6. Isipele bese Ubuyisela
Isipele Sedathabheyisi
Ukuze wenze isipele sedatha, ungasebenzisa umyalo othi `mysqldump` emgqeni womyalo:
“`sh
mysqldump -u impande -p db_tutorial > db_tutorial_backup.sql
``
Lo myalo uzodala ifayela elithi `db_tutorial_backup.sql` eliqukethe yonke idatha kanye nesakhiwo sedathabheyisi ethi `db_tutorial`.
Buyisela Isizindalwazi
Ngoba buyisela isizindalwazi kusuka kufayela eliyisipele, sebenzisa umyalo olandelayo:
“`sh
i-mysql -u impande -p db_tutorial <db_tutorial_backup.sql
``
7. Ukusebenzisa i-PHP ukuze uxhume ku-MySQL
Ukuze udale izinhlelo zokusebenza zewebhu eziguquguqukayo , uvame ukudinga ukuxhuma i-MySQL nolimi lokuhlela olufana ne-PHP. Nasi isibonelo esiyisisekelo:
ILangkah 1: Ikhodi Yokubhala Ukuxhumana
Dala ifayela elisha elibizwa ngokuthi `connect.php` bese ufaka ikhodi elandelayo:
"'php
die(“Uxhumano lwehlulekile:” . $conn->connect_error);
}
phinda “Kuxhunywe ngempumelelo”;
?>
``
Faka esikhundleni 'iphasiwedi' ngephasiwedi yakho yempande.
Isinyathelo 2: Finyelela ngesiphequluli
Vula ifayela elithi `connect.php` kusiphequluli sakho. Uma uxhumano luphumelele, uzobona umlayezo othi “Kuxhunywe ngempumelelo.”
8. Imikhuba Emihle Kakhulu Ekuphathweni Kwedathabheyisi
– Ukusebenzisa ama-Index: Ama-Index angasheshisa eminye imisebenzi ethi KHETHA, FAKA, BUYISA, kanye ne-DELETE.
– Ukulungisa: Ukunciphisa ukuphindaphindwa kwedatha nokuqinisekisa ukuhambisana kwedatha.
– Ama-Backup Avamile: Njalo yenza ama-backup avamile esizindalwazi sakho ukuze ugweme ukulahleka kwedatha.
– Ukuphepha: Qiniseka ukuthi usebenzisa izindlela zokuqinisekisa eziqinile futhi ukhawulele ukufinyelela kudathabheyisi.
Isiphetho
Kulesi sifundo, sihlanganise izinyathelo eziyisisekelo zokufaka i-MySQL, ukudala izizindalwazi namathebula, kanye nokufaka nokuphatha idatha. Lokhu kunikeza isisekelo esiqinile sokuqala ukusebenza ne-MySQL kumaphrojekthi akho. Khumbula njalo ukulandela imikhuba emihle yokuphathwa kwesizindalwazi ukuqinisekisa ukusebenza kahle kanye nokuphepha. Sithemba ukuthi lesi sihloko sibe usizo, futhi ngikufisela inhlanhla!
