The Mhando chikuru Mysql date

Nokuti vaya vasingazivi chii Mysql, kukuzivisai kuti ichi zvinobatsira chaizvo maitiro unokubvumira kushandisa yakawanda mashoko. Zviri pachena uye kuwanikwa vanoshandisa pamusoro ezvinhu zvavo rezinesi. Pakutanga kwezana zvigadzirwa kombiyuta "warehoused" mashoko kupinda yoga mafaira, uye ipapo akabvisa izvozvo kwavari sechinhu. Nhasi, izvi hurongwa havawanzoenda inobudirira, nokuti zvinotora nguva yakawanda nesimba. Mysql Software anokubvumira reumwe humboo uye kuvhiya pamusoro arrays ane mashoko achishandisa zviduku murayiro yekubvuma.

Kuti ari Database kushanda zvakanaka, pane pfungwa iri Mysql date mhando. Total akataura nhamba zvaungasarudza izvi:

- gat (n) kana VARCHAR (n) - chiratidzo, apo N - nhamba bytes zvinogona kushandiswa (VARCHAR zvitoro anopfuura 255 vatambi);

- tambo date zvifananidziro mysql, kusanganisira zvinotevera zvinogona: TEXT (n) - apo N inogona kusvika 65,535, TINITEXT (n) - apo N ave ukoshi kusvika 255, MEDIUMTEXT (n) pamwe N 16 777 215 uye LONGTEXT ( n) ari shanduka n, izvo zvinogona kusvika 4294967295 (kubva VARCHAR shanduka TEXT inozivikanwa pane TEXT (n) indexed rokutanga n vatambi);

- VARBINARY kana BINARY - kuchengetera mifananidzo binary remitemo ;

- yokuchengetera binary zvinhu makuru vasanonoka vatambi vaishandisa mashoko mhando Mysql BLOB (n), izvo zvakafanana divi uye "chivakashure", sezvo TEXT (TINY-, MEDIUM-, LONGBLOB) ; Somuenzaniso, MEDIUMBLOB (n) rine divi N kuenzana 16.777.215;

- Data mhando kuti zuva uye nguva, kusanganisira: DATE - musi mugore-mwedzi-musi format, nguva - nguva iri awa yemaminitsi-wechipiri format, gore - makore kubvira 1901 kusvika 2155, uye gore 0000, mumwe DATETIME - Chine DATE uye nGUVA (okupedzisira mhando nemashoko airatidza pamanyorerwo gore-mwedzi-musi-awa yemaminitsi-wechipiri); pane zvakare mhando Mysql umboo Format ari TIMESTAMP, izvo zvinoita kuti uite Database makore kubvira 1970 kusvika 2037 (uyu anokonzerwa nokufungidzira wegadziriro creators kuti Mysql zvachose zvisingachashandi ne 2037);

- Numeric, izvo ayo sezvamunoita vane integer Data mifananidzo, kusanganisira - Int - integer kubva munenge mabhiriyoni 2.1 kuti $ 2.1 billion, minus, TINYINT - .. A nhamba kubva 128 kusvika 255, kana kubvira -127 kusvika 0, SMALINT - kubva 32 768 kusvika - 32 767, BIGINT - kubva 9 x 10 negore regumi namasere dhigirii kuti -9 x 10 negore regumi namasere dhigirii, MEDIUMINT - kubva 8,388 miriyoni. kuna -8,388 miriyoni. (kana imwe mhando date yakatarwa nhamba mukuru kufadza wakatarwa, zvichava truncated kuti dzinoshanda tsika).

Panewo nemakirasi fractional nhamba - ichiyangarara - ndiko zvinoyangarara nhamba pfungwa, DOUBLE, uye CHAIYO - nhamba hunyambiri arambe achirema kuyangarara pfungwa, pamusoro Numeric uye grade - a fractional nhamba inochengetwa somunhu tambo. The zvirongwa anonyanya kushandiswa ichiyangarara uye Int, inotsigira nechigadziko anoshanda Zvakanyanya Kunaka Panguva Yepamuviri nokukurumidza.

Kushanda Database kuburikidza PHPMyAdmin mudziyo, kunouya vakasununguka Denver pasuru. Narwo unogona kuumba Database, chaiyo mazita Database matafura uye zvakasiyana-siyana data, mavara echivande. Ipapo mujinga yakazara mashoko, zvinokwanisika kusika munhu kutsvaka chikumbiro (Sarudza), kuchinja (CHANGE, RENAME, yokugadziridza), deletion (Kudzima), wedzera (wedzera) kana kufambira kuti anowanika mashoko uye goho parameters kurondedzerwa pamadziro. Mysql date mhando iyi inofanira kuwedzerwa nokungwarira zvikuru purogiramu havana kupiwa zvikanganiso. Somuenzaniso, unogona kutaridzwa mhando mashoko nokuda VARCHAR, izvo zvinoita kutanga acho ari Database anopfuura 255 vatambi. Zvino achizadza pechingoro chinyorwa achava unokosha zvikuru, izvo zvichaita kuti chokwadi chokuti Mysql "truncate" rugwaro kuti zvinogamuchirika kureba.