Munyika yemadhatabhesi uye data manipulation, timestamps ndeye quintessential. Ivo vanopa rekodhi chaiyo yekugadzira data kana kugadziridzwa mudhatabhesi. MuSQL, kazhinji zvinodikanwa kuseta kukosha kwechidhindo chenguva kuti ive iyo ikozvino timestamp. Izvi zvinonyanya kubatsira muzviitiko apo isu tinoda kuteedzera nguva yakaitika chimwe chiitiko kana chero zvakadaro, panodiwa nguva yekusarudzika. Ichi chinyorwa chichajekesa pane ichi chikamu cheSQL programming.
MySQL
Yakagadziriswa: group_concat distinct
Group_concat distinct ibasa rine simba muSQL, rinokutendera kuti ubatanidze kukosha kwakawanda kubva muboka remitsara kuita tambo imwe chete, yakaganhurwa. Mibvunzo iri mudhatabhesi inowanzoda kuti iwe uwane mibairo yakasiyana, uye boka_concat rakasiyana rinokubatsira kuti uwane izvo nenzira yakarongeka. Dambudziko rinosangana nevazhinji nderekuwana kukosha kumwe chete kubva kuboka rezvikoshero kana kubatanidza ese akasiyana hunhu kuita koramu imwechete kuti zvive nyore kurevera.
Yakagadziriswa: isa mysql raspberry pi
Kuisa MySQL muRaspberry Pi inzira yakakosha, kunyanya kana uri kutarisira kushandisa Pi yako sevhavha kana kubata data uye dhatabhesi. Inogona kunzwika setambo yakaoma kufamba pakutanga, asi nekuchenjerera nhanho-ne-nhanho kuuraya, inogona kuitwa zviri nyore. Ichi chinyorwa chinokutungamira kuburikidza nekuisa maitiro eSQL paRaspberry Pi uye ichatsanangura mashandiro emaraibhurari anodiwa uye makodhi eyakatsetseka yekuisa chiitiko.
Yakagadziriswa: mira password password
Mitemo yepassword inoita basa rakakosha mukuona kuchengetedzeka kwedata remushandisi, kusanganisira kudzivirira kupinda kusingatenderwe uye kuchengetedza ruzivo rwakadzama. Kusimbisa mutemo wakasimba wepassword kwakakosha kuchengetedza kutendeseka, kuvanzika, uye kuwanikwa kwedata rakachengetwa muhurongwa hweruzivo. Nekudaro, kutonga uye kuteedzera password password dzimwe nguva zvinopa dambudziko. Ichi chinyorwa chinopa mhinduro kudambudziko kubva kune SQL yekuvandudza maonero, ichipa nhanho-ne-nhanho gwara rekuita uye nekusimbisa password password uye inodiwa SQL kodhi inobatanidzwa. Pamusoro pezvo, isu tichanyura mukati meakakosha SQL mabasa uye maraibhurari ane hukama nepassword policy management.
Yakagadziriswa: shandura password yemushandisi
Chokwadi, ndapota tsvaga chinyorwa chakatsanangurwa pazasi:
Kuchinja password yemushandisi muSQL ibasa rakapararira kune vatariri vehurongwa uye vanogadzira zvakafanana. Izvo zvakakosha kuti ugare uchivandudza uye kusimbisa matanho ekuchengetedza kuchengetedza data remushandisi, imwe yacho inosanganisira kugara uchivandudza mapassword. SQL zvinyorwa zvinopa kugona kubata aya mabasa nemazvo.
Yakagadziriswa: gadzira kuisa mysql workbench
Chokwadi, ini ndichapa mhedziso yenyaya yacho.
MySQL Workbench chishandiso chakabatana chekuona chevagadziri vedatabase, vanogadzira, uye maDBA. Iyo inopa data modelling, SQL kuvandudza, uye yakazara manejimendi maturusi ekumisikidzwa kweseva, mushandisi manejimendi, backup, uye zvimwe zvakawanda.
Kuisa MySQL Workbench pane yako system dzimwe nguva kunogona kuve dambudziko, kunyanya kana iwe usina kunyatso kudzidzira mukushandisa mutsara wekuraira kana terminal. Asi, nerubatsiro rweHomebrew - yakavhurika-sosi software package management system - maitiro anova nyore.
Yakagadziriswa: uninstall mysql pa ubuntu
Uninstalling MySQL paUbuntu rinogona kuva basa rakakosha paunenge uchitsvaga kuisa vhezheni itsva, bvisa yakashatiswa kuisirwa kweMySQL, kana kungosunungura zvimwe zviwanikwa zvehurongwa. Kuziva kuita izvi nemazvo uye nemazvo kunokuchengetedza kusuwa kwakawanda uye kunovimbisa kuti hapana mafaera asara anosara anogona kukanganisa kuisirwa kweramangwana.
Yakagadziriswa: mysql_secure_installation
MySQL inomira seimwe yeakanyanya kusimba uye akakurumbira database manejimendi masisitimu. Inoshanda sedombo repakona rekuwanda kwewebhu-based application, nekuda kweiyo yakavhurika-sosi hunhu uye kuenderana neakasiyana mitauro yekuronga. Chinhu chakakosha chekushanda neMySQL chinosanganisira kuisirwa kwayo kwakachengeteka, kwakanzi 'mysql_secure_installation'. Iyi script inobvumira yakakwira chengetedzo layer, ichipa nzira yekubviswa kwevasingazivikanwe vashandisi, midzi yekupinda, uye bvunzo dhatabhesi, kuderedza kushandiswa kunogona kubva kune vane farious vashandisi.
Yakagadziriswa: ratidza zvakasiyana
Izvo zvakakosha kuti unzwisise mashandisiro e "SHOW VARIABLES" command muSQL sezvo ichigona kutipa hupfumi hweruzivo nezve magadzirirwo eMySQL server. Uyu murairo unosiyana-siyana unopa nzira ine simba yekuti isu tione uye tigadzirise zvinosiyana zvinogona kukanganisa mashandiro uye basa remashandiro edu.
Kugadzirisa zvinoshanduka zvinobudirira kunogona kuwedzera zvakanyanya kushanda kwekubata kwedu data uye, pakupedzisira, kutungamirira kune zviri nani kubuda uye kwakasimba kutonga pamusoro peSQL server yedu.