Samar da wani tebur a cikin MySQL Create Table data

Database, kamar yadda bambance-bambancen karatu da taro na bayanai da matukar muhimmanci, kuma ba tare da su ba zai iya yi ko da a kananan aikin. Yadda yadda ya kamata tunanin fitar tsarin, yadda ya kamata tsara Tables, musamman sadarwa - ya dogara da samfurin kudi / rubuta bayanai, data AMINCI, tabbatar da rashin yiwuwar mai haɗari wata cũta, kasancewa rollback, da cikawa na kowane ma'amala - da kuma nasarar da dukan.

A database ne da farko - na ra'ayi ra'ayin, gabatar da bayanai, da kuma dabaru na da amfani a wani musamman aiki.

Simple tasiri aiwatar rabo =

Da zumunci ra'ayin shirya data fili ba mafi kyau, amma da suka amincewa rike da matsayi na shekarun da suka gabata. Kamar yadda masana'antu domin samar da abinci da kuma muhimmanci da kaya zuwa da mabukaci, suna shakka da ake bukata.

Revolutionary ideas a cikin bayanai zahiri da yawa sau ayyana su da hakkin rayuwa, amma wannan rana kasa samar da gagarumin shaidar kasancewar irin wannan dama. Kamar yadda a kullum, da sauki - manyan nasarori. Duk da haka, da topic na dangantaka da kuma alakar da ke tsakanin bayanan abubuwa - maki, da kuma tsarin a bayanai sarari - har yanzu cike da farin spots, kuma ban sha'awa surprises.

Da ake ji sauki tsarin MySQL haifar da tebur take kaiwa ga samuwar na sauki da kuma dace don amfani da dama Tables, formalizing ikon yinsa matsala. Fara amfani da "tsoka" ne mai sauqi qwarai, amma bayan na farko da tebur goma na da zumunci dangantakar ba Yunƙurin zuwa wani daban-daban hali zuwa bayani, gabatar, ajiya da kuma yin amfani.

Wucin gadi, sarrafawa da kuma m

Salient aya: "da muhimman hakkokin ginin" database Concepts ba tare da sa hannu na MySQL, wanda ya zo wurin rayuwa tare da Internet shirye-shirye da kuma ya zama wani muhimmin ɓangare na shi. Dynamic, fasahar zamani ta yarda da database zama mai azumi, abin dogara da kuma tasiri, sauki koyi da amfani.

Bugu da kari ga babban alluna haifar wucin gadi tebur MySQL zane damar da shirye-shiryen don ƙirƙirar wucin gadi data Tsarin zama a lokacin yanzu zaman, ziyarar da wani mai amfani, abin da ya faru na wani takamaiman taron.

Idan kafin allunan da kuma dangantakar dake tsakanin su da aka bi a matsayin wani abu indisputable, amma yanzu ba a karɓa ko da iko database to koma zuwa muhimman hakkokin abubuwa. Wannan shi ne kawai mataki wajen fahimtar tsarin da bayanai da ake bukata don magance matsalar.

Ta samar da kayan aiki don ƙirƙirar wucin gadi Tables, haifar da wucin gadi tebur, MySQL ba ka damar raba database a tsaye da kuma tsauri aka gyara. Tantancewa da iri filayen a tebur, da shirye-shiryen za a iya ta atomatik sarrafa daidaitar da samuwar. Amfani da MySQL haifar da tebur rajistan shiga zane, da zanen iya saka da yanayi na ciko da filayen. Duk da yake wannan wani zaɓi - wajen wata damar sauƙaƙe hijirarsa na kayayyaki daga sauran SQL yaruka.

Bayani Space: sharuddan da tsarin

Kowane aikin, shin yana da dukan site, guda page ko wani sauki algorithm, aka located a wani wuri mai wasu bayanai sarari. "Address" na wuri - wani takamaiman aiki, da yanayi na zama na algorithm: da bayanai gininsa a kan mashiga ruwa da kanti, Forms hira tsari.

Duk da haka, ba dole ba ne bi da dokokin MySQL, haifar da tebur ba zai iya haifar da cewa daidai da ta cakude.

A wannan misali, filin code_back, owner_code session_code ayyana makullin da kuma bi da bi koma, da kuma abokin ciniki zaman. Ba wai kawai da yin amfani da wadanda ba misali version of MySQL haifar da tebur, key nan ba ya karya a filin na iyawa, da kuma fentin a cikin ma'anar: dawowar code a cikin hali na ba-kammala ma'amala, da aiki abokin ciniki code da zaman code, wanda zai iya zama da dama ga abokin ciniki, amma ya dogara da shi, inda code zai tafi sama management.

Akwai kuma yin amfani da wadanda ba misali filayen h_code, a_contents da a_surprise. Ga haifar da tebur MySQL misali na yadda daya filin iya ƙunsar bayanai, da kuma ilimin harsuna. A wani halin da ake ciki inda kana da wani tebur na abokan ciniki, shi ne mai hikima don ƙirƙirar wani cache na aiki ɓangare na tebur. Wannan ba dole ba ne yin shi da wani isasshen farko data tsarin. Alal misali, a_contents filin abubuwan: sunan, kalmar sirri. E-mail, da kuma a_surprise filin - yanzu jihar na mai amfani.

A ra'ayin a_contents da / ko a_surprise

Irin wannan embodiment ba ya bukatar samun babban tebur, wanda zai iya zama manyan da kuma amfani da tsauraran matakan, kuma za ta iyakance kananan, dauke da kawai dacewa bayanai. Ga haifar da tebur MySQL - wani misali na abin da za a iya yi shigar abokin ciniki sunan da kalmar sirri, ko da kalmar sirri da kuma e-mail a cikin sauki sharuddan: (a_contents kamar '{$ cUserName}. {$ CUserPass}%') ko (a_contents kamar '% {$ cUserPass}. {$ cUserName} ').

A wannan misali, yana amfani da da kansa aiki rajistan shiga na tebur: scTableExists ( 'rm_cache') kamar yadda idan tebur ne ba, za ka bukatar ba kawai don ƙirƙirar da shi, amma kuma rikodin, misali, da farko 'yan records da data hanya ma'aikata.

Standard bambance-bambancen haifar da tebur idan ba akwai MySQL embodiment yayi iyaka da kasancewa tebur da ta kafa a hali na rashi. Yawancin lokaci, wannan bai isa ba. Ya kamata mu ba kawai duba ga tebur, amma kuma cika shi da farko bayani.

sauki irin cell

Bayani dalla-dalla na MySQL yin amfani da harsuna, musamman PHP, yawanci minimizes da adadin m data: na farko, kuma farkon, netipirovannostyu ta canji. Da aka fi amfani kirtani, kamar yadda ake bukata - da lambar da kwanan wata, wani lokacin ma'ana data. More damar kwatanta data on MySQL haifar da tebur ƙunshi rare. Ko da yake karshen ne m da matsala da za'a warwaresu. Za ka iya amfani da dukan kewayon data via haifar da tebur MySQL, misali - wani zamani content management system website.

Abin da kuma yadda za a yi amfani da - ma'anar da developer. A wannan batu a lokacin, a cewar Wikipedia, da girma da kuma gudun fasali na MySQL iya saduwa da mafi capacious kwatanci na abokin ciniki, shan la'akari da gwaninta na developer amfani. Lokacin amfani a kan wani MySQL haifar da tebur default-Tsarin damar don ƙirƙirar tsabta (komai alluna) tare da sel m tsawon da ta samar da wata tsauri abun ciki a cikin tsari.

Complex data tsarin

Wayarwa zuwa sauki bayanai iri, da farko line, ya karfafa sha'awa a cikin zane na hadaddun bayanai tarar cewa a lõkacin da aiki tare da database da aka tuba zuwa ajiya a babban kirtani, lambobi (fihirisa - mafi sau da yawa), kwanakin, da kuma "babban data" - hotuna , sauti, sauran capacious ciki. Ga yare da haifar da SQL The tebur da MySQL kusan babu iyaka. Domin duk da sauki da kuma yin amfani da "tsoka" shirye-shiryen yana a ta zubar da cikakken ikon real SQL.

Outwardly sauki cikin sharuddan cell irin database char ko varchar tuba a algorithm for karanta a cikin wani cikakken abu - wani hadadden data tsarin (Properties, hanyoyin, ginin kalma da kuma ilimin harsuna), da kuma lokacin da rikodin sake kõma a cikin wani m tsari, jigon wanda aka ƙaddara da developer.

Naúrar tebur

shafi kawai, kawai Lines kuma daya kawai kashi a su mahada, kuma daya kawai irin - cell. Wannan shi ne ainihin mulkin tsarin MySQL "haifar da tebur". Babu MySQL data type ne ba na asali: adadin, hali kirtani, kwanan ... Yana ba ka bi daga ginin kalma, amma shi dai itace a yi.

Shirye-shiryen kwamfuta tafsirin tantanin halitta zai iya jure shi wani irin abu, saboda da bukatun na aiki. Daga hangen zaman gaba da database cewa "wani irin" - kawai line.

Duk da haka, ko da abin da, da kuma yadda za a amfani da developer fi son. Yana da muhimmanci cewa a wannan lokaci, a lokacin da (bisa ga Wikipedia) girma da kuma gudun MySQL sigogi iya gamsar da mafi capacious kwatanci na abokin ciniki, shan la'akari da gwaninta na developer amfani.

"Tenacious" ne mai sauqi qwarai tebur, shirya mafi sauki hanya. Idan developer yana sanya a cikin kõwace filin da ta dace ma'anar, couching shi a cikin wani char ko varchar irin cikin your MySQL haifar da tebur ginin kalma, da tebur za su yi aiki.

lamba tebur

Ya kamata mu ma magana game da fihirisa a MySQL. Ƙirƙiri tebur ba ka damar nan da nan bayyana su da amfani don samun damar babban kundin bayanai. Wannan dabarar ne sosai m, saba da kyautata wa irin wannan daki-daki, abin da ingantawa dogara a kan CPU gudu, caching samfurori artful lissafi Algorithms sau da yawa zaba data tace php.ini, my.ini da httpd.conf.

A halin yanzu, kome ya hana a developer don ƙirƙirar your own view "Data" - "makullin zuwa data" for sauki lamba - babu layuka a cikin tebur, kawai lambobi. A micro haifar da tebur int MySQL zai samar da duk dole Sauran tebur: sauki access, sauki aiki, cikakkun ayyuka a manufa gudun.

Integers, shirya matsayin real data katunan a manyan kuma ƙato Tables, zai gaggauta habaka zabin da kuma gyara daga bayanai ba tare da wani matsaloli. Optionally ƙirƙirar version na key na samun tsawon lokacin da aikin, za ka iya amfani da haifar da wucin gadi tebur tsarin, MySQL Halicci wucin gadi tebur kafin amfani da shi. Ko, misali, ga kowane mai amfani - a key tebur.

A wannan mahallin, da ginin kalma ba a nuna da yin amfani da haifar da tebur idan ba akwai MySQL ba ka damar haifar da zama dole Tables, ko da wani m rashi, misali, an ba daidai ba labari / fitarwa ko kwamfuta hadarurruka, da kuma Indexing lalace.

A hakikanin hosting - MySQL +

Tarihi, da database ne mai ma'ana data tsarin. Design M ySQL haifar da tebur da farko bi gargajiya Concepts na bayanai da kuma su location a kan faifai sarari. Internet shirye-shirye, da kuma sama da dukan zabin hosting da dabaru na m content management system, sanya m, a duban farko, kawar da: daya tushe iya zama hade da dama. The rabuwa ne a kan tebur prefix sunan.

Wasu hosting samar lazimta a database sunayen bukatunsu, kamar da database sunan fara da sunan mai Hosting.

By kuma manyan, shi ba kome abin da ya kira da database da kuma yadda za a kira shi da wani tebur. Duk da haka, halin da ake ciki ya fara wakiltar ba kawai a MySQL ginin kalma da kuma bukatun da hosting da ginin kalma, watau MySQL +.

A kananan tebur, da sauki shi ne shirya, da kuma kasa da shi ya rubuta, da denser shi da maniyyi a cikin shirye-shirye da harshen ta hanyar abin da ake so ayyuka ake yi tare da bayanai.

A ka'ida, kowace aiki ne mai sauki a fenti a cikin na farko da aka gyara, da kawai tambaya ne, nawa za kudin irin wannan sauki.

Idan kana bukatar wani tsabta MySQL, shi kansa hosting naka uwar garke, inda za a yi ba hani a kan yawan databases ko da dokoki na ambata sunayen su, kuma su memba Tables.

A iri-iri iri na Apache / MySQL / PHP

Dogara a kan hosting yanayi - ba haka ba da matsala mai yawa, kamar yadda wani muhimmin sharaɗi ne ga wani zamani tsaron gida shirye-shirye. Za ka iya rubuta a PHP 7.0.13, amfani da MySQL 5.7.16, amma abokin ciniki za a hosting, barin kawai version of Perl da "tsoka" 4.1.1 ko wani mazan version of PHP.

A general (wanda, ba zato ba tsammani, ba da wani al'amari) hosting samuwa a kan Linux, FreeBSD, Ubuntu da sauran bambancin yunikosopodobnyh tsarin. Su duka aiki lafiya, amma kowanne daga cikinsu na da halaye, da nasu versions na majalisai HAU (Apache, MySQL, PHP). Ba ko da yaushe, kuma ba kowane tawagar da aka je aiki a cikin gaba version, ko da yake ta yi aiki a baya daya.

Irin wannan sauki aiki a matsayin database fitarwa wani version of MySQL ya aikata ba tare da matsaloli, duka daga Import Import phpMyAdmin, kuma daga umurnin line. Contact shigo da ayyukan ba zai iya faru. More sau da yawa fiye da ba dole canza wani abu a cikin PHP, MySQL uwar garke ko Apache. Idan canje-canje ba taimaka, shi wajibi ne don duba for zabi.

A sauki gaskiya, wani aiki za a iya yi da resetting da database, da shirye-shirye da harshen, ko da uwar garke. Wannan ba shine mafi kyau bayani, amma yawanci tasiri.

A database halittar / Ingancin tebur

Ginin kalma MySQL haifar da tebur da wuya m, a da misali embodiment. Idan ba a dauke a cikin mahallin da m content management system: za a zama kullum a classic na salo. A kullum aiki ne mafi sauki ga la'akari da shi a cikin mahallin yi: wanda filayen da ake bukata a tebur, wanda dole ne su sami wani irin girman. Sauran har yanzu bukatar tata da tsari na ci gaba: saitin harafi, irin tsari, makullin.

Ganiya ne version na algorithm, a cikin abin da ko da rashin wani database ba ya tsoma baki da shafin don farawa. Za ka iya rubuta naka aikin duba database da / ko tebur a lokacin da kuke bukata don ƙirƙirar ba kawai bayanai Tsarin, amma kuma ya cika a cikin na farko bayani.

Popular sau da yawa amfani da jerin kayayyaki Create tebur idan ba wanzu, MySQL ba mamaki da site mai ko wani baƙo da cewa ba zato ba tsammani ce: babu wani database ko tebur tsarin ya karye.

A yau ta shirye-shirye, da general mulkin "dõgara, amma tabbatar da" ba ya aiki, ko kuma wajen zai yi amfani da dabaru na "duba da amfani."

Ƙirƙiri tebur: MySQL mai amfani tebur samfurin

Rajista da sabon baƙi da kuma ƙofar / fita daga shafin masu amfani sun ɓullo da yawa sau, amma iyaka na kammala a cikin wannan muhimmin ɓangare na wani site tukuna.

A fannoni da dama, da shigar da / fitarwa da kuma rajista an tsare ta sharuddan tunani da shafin da kuma / ko amfani da abun ciki gudanar da tsarin, amma mafi sau da yawa - da muradi wani abu more amintacce, kare asusun mai amfani, Hana shiga ba tare da izini ba site.

Kullum MySQL database ne mafi amintacce fiye da wani website, amma idan akwai gajiyarwa, ba za a iya mulki nuni browser kuskure saƙonni na sanyi code na wata site, dauke da sunaye da kalmomin shiga da database.

Good yi - to raba bayanai a kan canzawa kuma tsauri aka gyara. A cikin misali na mai amfani tebur, za ka iya samun girma falle masu amfani da kuma aiki cache_users. A farko tebur ƙunshi manyan yawan masu amfani, na biyu - kawai wadanda suka yi aiki a ranar ƙarshe (misali). Kowane sabon mai amfani da cewa shi ne ba ya nan a karo na biyu da tebur, ya dawo bayan da login / rajista da kuma kiyaye don wani lokaci.

Amma da rabo a cikin alluna biyu a nan ba kawai ya samar da bayanai samfurin kudi (a kananan tebur ne ko da yaushe sauri fiye da ƙato da kuma manyan), amma kuma a gaskiyar cewa shi ya yi daidai kawai bayanai da ake bukata fiye da sau da yawa a lokacin da aiki da wani abokin ciniki da wani site. Domin daukan samfur ko data canje-canje da sauƙi amfani da babban tebur.

Memory, bayanai da kuma bayanai

A fagen bayanai fasahar ko ta yaya ya ba ɓullo da su wakilci memory shirye-shirye da harshen. Harshe - da canji, constants da kuma Tsarin, barin wani abu da kuma ko ta yaya nemi. Database - shi ne wani abu da adanar. Daga shi zaka iya ko da yaushe zabi wani abu a cikin shi za ka iya rikodin wani abu.

Hada harshe da kuma tsarin da manufar yin aiki tare da bayanai, amma dabaru na dangantaka a cikin wannan triad ba haka ba ne m har ma a wani sauki bunch HAU: Apache, PHP, MySQL. Ga duk abin da yake sarari: uwar garke, cikin shirye-shirye da harshen da database - duk abin da ake bukata ga masu rinjaye na ayyuka.

SQL harshen - wannan shirye-shirye da harshen, kuma lalle ne, haƙĩƙa, a cikin database na da dabaru ake gudanar, nasu shirye-shirye ra'ayi. A nan muna da marmarin database shirye-shirye gefe. PHP - mai kyau kayan aiki, amma a ce ya jajirce mayalwaci database gefe, shi ne wuya. Duk da haka, da tsarin da kuma ayyuka ci gaba da inganta.

Idan muka hada PHP da MySQL a guda naúrar, ka samu cikin kayan aiki, yana da wata memory. Option hade yake ba da ra'ayin abu-daidaitacce shirye-shirye: abu da aka bayyana a cikin harshen a lokacin da amfaninsa a ƙwaƙwalwar (a cikin database) a wani m jihar. Lokacin da ya zamo wajibi, shi ne rage a cikin wani cikakken abu da kuma aiki daidai da ta iyawa.