Ib tug kws paub tsis meej programmer feem ntau tau cuam tshuam nrog SQL lus nug thaum ua haujlwm nrog kev siv Internet. Feem ntau ntawm lawv yog blogs, kev sib tham lus, kev tswj hwm lub xaib, thiab lwm yam. - siv MySQL database hauv kev ua haujlwm. Rau DBMS no, muaj cov ntawv thov nrov heev uas tso cai rau koj los tswj ob tus tib neeg cov ntxhuav thiab tag nrho cov chaw khaws ntaub ntawv. Tsim cov lus nug SQL hauv PhpMyAdmin - qhov no yog lub npe ntawm daim ntawv thov no - muaj peev xwm ua tau ob qho tib si hauv cov ntawv sib tham thiab siv cov lus teb rau tus neeg teb xov tooj.
Tsim nyog
Siv PhpMyAdmin ntawv thov
Cov Lus Qhia
Kauj ruam 1
Thauj nplooj ntawv lub ntsiab ntawm daim ntawv thov mus rau hauv lub browser, sau koj tus username thiab password. Hauv kab ntawv sab laug ntawm thawj nplooj ntawv muaj cov kab ntawv txuas mus rau hauv lub databases muaj rau koj - xaiv qhov koj xav tau.
Kauj ruam 2
Tus txheem ntawm kab ntawv sab laug thiab sab xis yuav hloov - daim ntawv teev cov rooj yuav hloov qhov chaw ntawm daim ntawv teev cov npe ntawm sab laug. Yog tias koj xav ua cov lus nug rau cov lus tshwj xeeb, nyem rau ntawm kab txuas ntawd, thiab yog tias cov lus nug xa mus rau tag nrho cov chaw khaws ntaub ntawv, nyem rau ntawm SQL tab nyob hauv cov ntawv qhia ntawm kem sab xis. Tom qab xaiv lub rooj, xws li tab yuav kuj tseem nyob rau ntawm nplooj ntawv thiab koj kuj yuav tsum tau mus rau nws.
Kauj ruam 3
Ntaus koj cov lus nug hauv lub npov hauv qab "Execute SQL query (s) tiv thaiv mysql database:" Yog tias koj tsis tau xaiv lub rooj nyob hauv qib dhau los, daim teb no yuav khoob, txwv tsis pub muaj lwm qhov qauv rau hauv nws, uas yuav tsuas yog yuav tsum tau muab kho lossis kho ntxiv. Cov qauv no tuaj yeem saib, piv txwv li, zoo li qhov no: XAIV * LOS NTAWM `pab_ qeb 'QHOV TSEEB 1 Koj tuaj yeem nyem lub pob OK, thiab cov lus nug yuav raug xa mus rau lub chaw khaws ntaub ntawv - nws yuav xa cov npe ntawm txhua kab nrog txhua daim teb los ntawm lub rooj muaj npe pab_category.
Kauj ruam 4
Thaum tsim cov lus nug SQL rau lub rooj uas tau xaiv, koj tuaj yeem siv cov npe kab ntawv muaj nyob hauv nws - nws tau muab tso rau sab xis ntawm cov lus teb. Piv txwv li, koj tuaj yeem hloov kho cov qauv tsim rau daim ntawv hauv qab no: SELECT `url` FROM` help_category `WHERE` name` = "Geometric Concepts" Ua tib zoo saib rau cov cim kab lus: cov npe ntawm cov liaj teb thiab cov rooj - url, lub npe thiab pab_category - tsis siv rau cov cim kab cim cov cim uas tau muab tso nyob ib puag ncig cov ntawv sau (Geometric Qauv). Tom qab txhaj OK, cov lus nug no yuav xa cov kab ntawv ntawm cov rooj uas muaj qhov nqi "Geometric Constructions" hauv lub npe sau. Daim ntawv teev cov txiaj ntsig yuav muaj tsuas yog ib kab ntawv url, txij li tsuas yog nws tau qhia tshwj tseg tom qab SELECT cov lus.
Kauj ruam 5
Cov lus thov ib leeg tuaj yeem tsim online. Txhawm rau ua li no, nyem kab ntawv "Tshawb nrhiav" thiab sau rau lub rooj hauv qab "Cov Lus Nug" los ntawm cov qauv "ntawv sau. Rau cov piv txwv saum toj no, hauv cov lus no nws tau txaus los ntaus tus ntawv "Geometric Constructions" hauv kab "Tus Nqi" ntawm kab npe. Txhawm rau tsim cov lus nug ntxiv, nyem kab lus "Kab Txwv" txuas nyob hauv qab rooj, thiab ntxiv cov chaw sau thiab cov npe xaiv yuav qhib.
Kauj Ruam 6
Nyem OK thiab PhpMyAdmin yuav tsim thiab xa cov lus nug SQL rau lub database.
