How kusika munhu mysql Database

Kwete kuchikosha, ndokusaka muri kufarira mubvunzo sei kuti pave Database pakati ari mysql, zvakakosha, kana uine inokosha vanochengeta zivo, pasina iyo kutaura pamusoro anobudirira Implementation ari pamuviri hakusi zvakakodzera.

Munyaya ino I ichakurukura chiito kutora munhu ane PC, kana kuti zvimwe zvinangwa zvaida kuisa mysql, kuumba Database, uye edza ruoko rwavo vari kurapa Databases ano. zvichava saizvozvo kufarira vaya vanoda kuziva sei kuti basa ano Database.

Nokuti, sezvandambotaura, kuitira kuti zvose kwakashanda, tinoda vamwe ruzivo anokosha pasina iyo pave Database mysql haana kuwana data, ukuwo, isu vachafunga kuti unoziva Database pamatafura, queries kuti Database uye hauna kuisa deadlock chidimbu SQL. Uyewo, taifunga kuti iwe ndakagadza uye configured Apache Server.

Saka, kana zvose zvaunoda pamberi penyu, uye chido chokudzidza kuti pave Database mysql kuti asina akarasika, isu ichatanga kuti kumhanya Apache. Kumhanya nawo nzira C: \ WebServers \ nezvimwewo Mhanya uye kumhanya faira. Kana Apache kwakarurama, kukanganisa-isina kutanga, zvino rezasi rworudyi pakona kuti aivapo kuvake Wedzerai dzvuku kunyora.

Zvino unofanira nechokwadi chokuti paWeb server achimhanya, kupinda kero iri mubrowser http: // localhost / Pakuvada unofanira kuwana rugwaro Kana ukaona uri tarisisa, ipapo Apache kuitira "Hurray, aiwana!".

Zvino endai Tools uye kusarudza Import Import phpMyAdmin ari pamazita, une graphical goko unokubvumira mafambisirwo Database mySQL. Inogona kushandiswa kuvhiya zvose pasina chaakasiya; izvo yakabva creators ose Database ichi, uye zvakananga:

Kuumba Databases

Kuti vagadzire Database, mu "Sikai Database itsva" unofanira kupinda zita Somuenzaniso, MyBase. Zvino achizviendesa bhatani "Sikai" uye phpMyAdmin achasikei imwe Database idzva.

Kuumba matafura

Gadzira tafura riri nyore, unofanira kusarudza nechimwe (MyBase). In huru hwindo vari chakaita kupinda zita patafura (kuedza kunyora zita DataStudent), uyewo vanofanira kupinda nhamba yeminda (yakatarwa nhamba 5). Kana uchisarudza sei iwe uchava minda, usakanganwa kuti mumwe munda anoenda pasi kiyi (ID). Kana wakapinda nemazvo - wokudhinda «Kupinda» bhatani.

Zvino uchava kuzarura chimwezve fomu kusika matafura. Mariri unogona kutaridzwa munda, basa mashoko mhando kune mumwe nomumwe wavo, ainzi mbiru, kuona kunonyanyisa hukuru hwavo. Kazhinji, wokutanga munda kiyi. zita rake wakapinda mune «ID», zvino zvakakodzera kuona mhando Data kuti wakapinda kuti mbiru iyi. Sezvo iyi mhando MySQL, pakaunda hakuwaniki, sarudza Int, hunhu akaisa cheki unsigned. Zvadaro endai yepamusoro pazviruva uye ipapo Auto-increment, saka kuti mumwe nguva yaunosuma kukosha mutsva, munda uyu vakazvimiririra kunowedzera kukosha kwayo mumwe.

Saka, imi anoguma nezvaiitwa pakaunda. Ndiyo nguva kuenda pane inotevera boka muzviruva - RadioButton. Pano, sarudza "chikuru" kana kusashanda - kuti munda wedu kiyi chikuru.

Kana iwe wakaita zvose zvakarurama, chikuru munda iwe configured zvakanaka, kana iwe wedzera mitsara kwariri rwoga kunowedzera ukoshi ID. Uye iwe wava mumwe danho pedyo kunzwisisa sei kuumba MySQL Database.

Kufambira mberi, tinofanira zvino vanofanira kutsanangura tsika uye kupa mazita mamwe mbiru patafura yedu. Ngazviitwe muminda. Last zita, wokutanga zita uye, somuenzaniso, kufungidzira: «Fam», «Name», «Otch», «Ocenka», akasiya kuti kupa mhando date - varChar, nokuti minda izvi achachengeta mashoko ari muchimiro mutsetse. Musakanganwa kuti kuisa kufadza urefu uye minda vaizova musoro chete mumwe kukosha 30 vatambi. Check zvose Entries uye mabiko meso ako patafura makasika. Inofanira kuva akagadzirwa kusango «ID» mazita, «Fam», «Name», «Otch», «Ocenka».

Ndinovimba kuti mashoko ari munyaya ino zvinobatsira iwe, uye iwe mairi vakawana mhinduro yomubvunzo wokuti sei kuti pave MySQL Database.