Nyob rau lub sijhawm luv luv, SQL hais kom hloov pauv cov ntaub ntawv raug suav nrog hauv kev faib tawm ntawm MySQL cov chaw tswj kev tswj hwm. Yog li ntawd, yog tias koj yog cov neeg siv zoo siab ntawm ib qho ntawm MySQL version, ntawm 5.1.7 rau 5.1.22, tom qab ntawd koj tuaj yeem siv RENAME cov lus txib. Txij li thaum version 5.1.23 qhov kev hais kom ua no tau raug tshem tawm uas muaj kev phom sij txaus ntshai. Txhawm rau pauv cov ntaub ntawv hauv lwm phau ntawv, koj yuav tsum tau siv txheej txheej los tsim cov ntaub ntawv tshiab, theej cov ntxhuav qub rau hauv.
Tsim nyog
PhpMyAdmin ntawv nkag
Cov Lus Qhia
Kauj ruam 1
Siv daim ntawv thov phpMyAdmin yog tias koj xav tau txhua qhov kev coj ua xav tau hloov npe rau cov ntaub ntawv khaws cia tau tsim thiab xa mus rau SQL tus neeg rau zaub mov. Daim ntawv thov no yog muab los ntawm feem ntau cov tuam txhab hosting ua haujlwm puv sijhawm MySQL database tswj cov cuab yeej. Yog tias koj siv cov SQL server hauv zos, tom qab ntawd nruab nws rau koj lub khoos phis tawm - nws tsis yog qhov nyuaj kom nrhiav tau qhov ua tiav ntawm Lavxias nyob rau hauv Is Taws Nem, thiab cov ntawv tawm tshiab tuaj yeem tau pub dawb los ntawm lub vev xai
Kauj ruam 2
Nkag mus rau hauv phpMyAdmin application thiab hauv daim ntawv teev npe ntawm koj tus lej teev nyiaj hauv tuam tsev nyob sab laug thav duab ntawm qhov sib cuam tshuam, nyem qhov khaws koj xav hloov npe. Qhov kev zov me nyuam yuav thauj cov nplooj ntawv nrog cov npe ntawm cov ntxhuav xaiv ntawm cov ntaub ntawv, cov ntaub ntawv cuam tshuam nrog lawv thiab cov txheej tswj hwm cov npe khoom.
Kauj ruam 3
Xaiv Kev Ua Haujlwm los ntawm cov ntawv qhia zaub mov rau sab saum toj ntawm txoj cai thav duab thiab phpMyAdmin yuav thauj cov nplooj ntawv tshiab rau hauv cov ncej ntawd. Nws muaj cov thawv sau pob rau peb lub haujlwm, suav nrog kev pauv npe rau lub chaw khaws ntaub ntawv.
Kauj ruam 4
Qhia lub npe tshiab ntawm cov ntaub ntawv nyob hauv nqe lus nrog cov ncauj lus "Hloov npe ntawm lub hauv paus rau" thiab nyem khawm "OK" hauv tib seem. Qhov kev zov me nyuam yuav sau cov txheej txheem tsim nyog rau kev tsim cov ntaub ntawv tshiab nrog lub npe koj teev, luam cov ntxhuav ntawm cov chaw khaws ntaub ntawv tam sim no rau hauv nws thiab tom qab ntawd muab lwv tawm. Txij li thaum tseem muaj kev tshem tawm txoj haujlwm hauv cov npe ntawm SQL cov lus txib, phpMyAdmin yuav nug koj kom paub tseeb - nyem "OK".
Kauj ruam 5
Yog tias qhov version ntawm SQL neeg rau zaub mov raug siv nkag siab txog cov lus ntawm qhov ncaj qha rau kev hloov npe, tom qab ntawd koj tuaj yeem siv cov lus txib SQL nram qab no: RENAME old_name TO new_name; Ntawm no old_name yog lub npe qub, new_name yog tus tshiab. Qhov zoo ntawm qhov kev xaiv no yog qhov txo qis ntawm lub sijhawm ua tiav ntawm kev ua haujlwm.
