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 seoMunda 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.
Kutanga kwekutanga uye Kuvandudza kweTIMESTAMP uye DATETIMEChii 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.
Yoann Bierling ibhusaiti yekushambadzira & Dhijitari Kukurukurirana Professional, kugadzira kukanganisa kwepasi rose kuburikidza nehunyanzvi uye hunyanzvi mune tekinoroji. Passionate nezve kupa simba vanhu uye masangano kuti akubudirire muzera redhijitari, anofambiswa kununura mhedzisiro yakasarudzika uye yekufambisa ichipfuura kuburikidza nedzidziso yezvinyorwa zvemukati.
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