mySQL yakasikwa uye yakarongedzwa nguva

Phpmyadmin yegadzira tafura yemazuva ano

Kuumba minda ne nguva zvidhori zvinenge zvakasikwa uye / kana kugadziriswa kwekupedzisira mazuva muMySQL uchishandisa PHPMyAdmin yakananga.

Hapana chidimbu cheSQL code chaiyo mumashanduro emazuva ano, sezvo zvino zvinoita kuti ive neminda miviri yakasiyana mune imwe tafura ine timestamp yemazuva ano sekusavapo, uye saka hapana chikonzero chekushandisa zvinokonzera zvakare nekuda kwechinangwa ichi.

Mune tafura yekusika interface, wedzera miviri miviri - imwe yezuva rekusika, uye imwe yekugadziriswa - pamwe nemasarudzo sezvinotsanangurwa: zvose sematestamp, timestamp yemazuva ano sechinhu chisina kukwana, uye chirevo pakuvandudzwa kwekupedzisira kugadziriswa zuva.

Kana yakasikwa, tafura yegadziriro inofanirwa kunge yakafanana neyozasi kwe screenshot.

MySQL tafura yezvisikwa zuva

Ita izvozvo nekugadzira mutsva wekupinda kwetafura:

Muchivara chekushandura, ona chinyorwa chako chitsva-zvisikwa zvose uye mazuva ekugadzirisa zvakaenzana.

Edza kuongorora imwe yehutano hweimwe yekupinda:

Uye ona zvakananga kuchinja: zuva rekushandurwa rakashandurwa kuti rienzane nenguva yekuchinja, uye nguva yekusika haina.

Izvo zvechokwadi zvakare zvinokwanisika kuzviita uchishandisa SQL, heino mutsara unowirirana:

Nzira yekugadzirisa MySQL yemazuva ekugadzira timestamp pakuumba nekuvandudza

Kuti ugadzire MySQL yemazuva ekutemesa patafura ichigadzira uye itafura yekuvandudza, paunenge uumba tafura, isa miviri miviri yakasiyana neyomutauro TIMESTAMP, uye iyo yakakwana yenhamo MYSQL yemazuva ekupedzisira, inonziwo nguva yemazuva ano. Ichishandurwa zuva remunda inofanirawo kuva nemafungiro ekugadzirisa nguva isina nguva.

Dzidza seo Basics: Nyoresa nhasi!

Simudzira kuoneka kwewebsite yako uye traffic nekumanikidza izvo zvakakosha zve seo neyedu nyore-kune-tevera basics kosi.

Tanga kudzidza seo

Munda wokutanga uchava nguva yekusika, uye inofanira kuva neyemutambo timestamp, uye yakasarudzwa yakaiswa panguva ino yemazuva ano. Paunenge uchitanga rekodhi itsva, munda iwoyo uchazadzwa ne MySQL yamatestamp yemazuva ano.

Munda wechipiri uchava shanduro yekugadzirisa, uye inofanirawo kugadziridzwa neyimbo ye timestamp, pamwe chete nehuwandu hwekuvandudzwa kweCURRENT_TIMESTAMP. Nenzira iyo, pakusarudza rekodhi, zuva rekushandurwa richaiswa kuMySQL yemazuva ekupedzisira. Uyewo, pose apo rekodhi ichagadziridzwa, shanduko ye timestamp field ichavandudzwa pamwe chete neMystamp yamatestamp yemazuva ano.

Chii chinonzi MySQL timestamp?

Iyo  MySQL timestamp   inzira yekumiririra nguva uye zuva zvachose, mune imwecheteyo chikamu chekuchengetedza.

A  MySQL timestamp   inotangira kubva kutanga kwaJanuary 1970 mu server UTC nguva, kusvika 19 Ndira 2038.

Izvi zvinoreva kuti kushandiswa kweMySQL timestamp ishoma, sezvo vachazoda kuchinjwa gore ra2038, zvisinei hazvo kazhinji mukana unechekuita unenge uchitarisira izvo.

Iyo  MySQL timestamp   imwe yedzimwe nzira mbiri dzekuchengetera mune MySQL dhatabheji zvese zuva uye nguva, pamwe chete neiyo fomati format.

Izvo zvinowanzo zviri nani kushandisa iyo  MySQL timestamp   yekuchengetedza misi yakadai sekushandura uye yekugadzira zuva rekodhi mune MySQL database sezvo iri iyo nzira inodiwa yekushandisa zuva uye nguva mukati me database.

Nekudaro, zvese izvi kukosha pamwe chete nechiyero cheti fomati zvakabatana, uye zvinogona kushanda pamwe.

Mibvunzo Inowanzo Bvunzwa

Maitiro ekuwedzera MySQL yakagadzirwa uye yakagadziridzwa Timestamp?

Kuti ugadzire nguva yekodhi yakagadzirwa uye yakagadziridzwa mudhiri yeMySQL, unogona kutsanangura minda miviri neiyo timestamper mhando uye isa iyo default kukosha kune iripo timestamp. Kune iyo nguva yakagadziridzwa nguva, wedzera iyo hunhu pane yekuvandudza iripo_timestamp. Izvi zvinovimbisa iyo yakagadzirwa nguva yakagadzirwa kana iyo itsva rekodhi yakawedzerwa uye iyo nguva yakagadziriswa nguva inoratidza iyo nguva ino chero nguva iyo Rekodhi rashandurwa.

Ndedzipi nhanho dzinokosha dzekutengesa kunze kwenyika uye kuendesa sosi yeshoko kune imwe dunhu idzva pasina kurasikirwa seo rankings?

Makumbo akakosha anosanganisira kugadzira backup yakazara yesaiti, achichinja marongero ezviitiko zvekutengesa kune yekare kuenda kuGoogle yekuchengetedza SEO, uye kuzivisa Google yekuchinja kuburikidza neGoogle yekutsvaga yeGoogle. Kuverengera zvidiki zvidiki zvekutenderera uye kuchengetedza ese saiti data uye seo marongero akakosha mukati meiyo maitiro.