Mhinduro dzinobata simba rekodhekisi yako
A database inotsvaga zvinyorwa zvinyorwa kubva kune database uye inozvigadzira nenzira inogona kuverengwa. Mhinduro inofanira kunyorwa mumutauro iyo database inoda-kazhinji, iyo mutauro iSQL .
Semuenzaniso, kana iwe uchida deta kubva kune database, unoshandisa mubvunzo kuti ubvunze ruzivo rwakananga rwaunoda. Zvichida une tafura yevashandi, uye iwe unoda kutarisa kutengesa nhamba nhamba. Iwe unogona kutsvaga tsvakurudzo yako kune mushandi uyo akanyora kukosha kwekutengesa mune imwe nguva.
SQL SELECT Statement
Tsvakiridzo yepa database inofanira kutevera fomu yemibvunzo inodiwa ne database. Nzira yakanyanya kufanana ndiyo Yakagadziriswa Mutauro Mutauro (SQL) yakagadziriswa yemibvunzo yakagadziriswa inoshandiswa nemaitiro akawanda ekutungamirira magwaro. SQL iri mutauro une simba unogona kunyanya kubvunza mibvunzo.
SQL inoshandisa chirevo cheCHISUNGWA kuti usarudze data yakananga.
Chimbofunga muenzaniso unobva pane database yeNorwwind inowanzoendeswa nemigadzirwa yemagwatidziro semudzidzisi.
Heino zvakanyanyisa kubva patafura yeVashandi veDesource:
| VashandiID | Zita rokupedzisira | Zita rokutanga | Title | Address | Guta | Nharaunda | |
|---|---|---|---|---|---|---|---|
| 1 | Davolio | Nancy | Sales Representative | 507 - 20th Ave. E. | Seattle | WA | |
| 2 | Fuller | Andrew |
| 908 W. Capital Way | Tacoma | WA | |
| 3 | Leverling | Janet | Sales Representative | 722 Moss Bay Blvd. | Kirkland | WA |
Kuti udzoke zita romushandi uye zita kubva pane d database, mutemo WOKUTA unogona kutarisa chimwe chinhu chakadai:
Sarudza FirstName, Lastname, Title FROM Employees;
Ringadzoka:
| Zita rokutanga | Zita rokupedzisira | Title |
|---|---|---|
| Nancy | Davolio | Sales Representative |
| Andrew | Fuller | Vachigaro wePurezidhendi, Sales |
| Janet | Leverling | Sales Representative |
Kuti uwedzere migumisiro inowedzera, unogona kuwedzera chirevo che WHERE:
Sarudza Zita Rokutanga, Zita Rokupedzisira KUVashandi
WHI Guta = 'Tacoma';
Inodzorera FirstName uye LastName yeVashandi vanobva kuTacoma:
| Zita rokutanga | Zita rokupedzisira |
|---|---|
| Andrew | Fuller |
Cherechedza kuti SQL inodzoka dhesi mufomu / mutsara imwe yakafanana neMicrosoft Excel, zvichiita kuti zvive nyore kuona nekushanda. Mimwe mhinduro dzemitauro inogona kudzoka dhese se grafu kana chati.
Simba reMibvunzo
Dhina rekodhi ine simba rokuratidza maitiro akaoma nemabasa, asi simba iri rinongorongedzwa kuburikidza nekushandiswa kwemubvunzo. Dhina yakawanda yakawanda inoumbwa nematafura akawanda kuchengetedza zvakawanda zve data. Mhinduro inokubvumira kuisvina iyo imwe tafura kuitira kuti iwe ugone kuinyatsoongorora.
Mhemberero zvakare inogona kuita maverengi pane data yako kana kuchinja maitiro ekutungamirira data. Iwe unogona zvakare kugadzirisa zvishandiso kune data yako usati wazviisa kune database.