MySQL Isilumkiso: Kufunyenwe umqolo apho i-auto_increment kholamu

mhlawumbiEzorhweboUmlawuli wesiza uneemvume ezaneleyo zokudlulaphpMyAdminiphaneli yolawulo lwesiseko sedata, eweMySQL databaseYenza imisebenzi yokulondoloza.

Xa kukho impazamo kwisiseko sedatha, unokunikaWordPressIziko ledatha lenza ukulungiswa kwetafile "analyses" okanye "checks".

Kodwa ke umyalezo wemposiso onje unokuvela:

• wp_postmeta hlalutya isilumkiso Kufunyenwe umqolo apho umqolo ozenzekelayo_wonyuso unexabiso elingu-0 
• wp_postmeta jonga isilumkiso Kufunyenwe umqolo apho umqolo wokwandisa_ozenzekelayo unexabiso elingu-0
• Kufunyenwe umqolo apho ikholomu_yonyuso oluzenzekelayo ine...
   

Oku kulandelayo yinguqulelo yesiTshayina:

• isilumkiso sohlalutyo lwe-wp_postmeta lufunyenwe umqolo apho ikholomu ye-auto_increment inexabiso elingu-0
• wp_postmeta khangela isilumkiso kumqolo ofunyenweyo apho ikholomu ye-auto_increment inexabiso elingu-0
• Fumana umqolo apho ikholamu yokwandisa_ezenzekelayo..

Kuthetha ukuthini ukongezwa kwe-auto yedatabase?

• ukunyuka
• British ['ɪŋkrɪm(ə)nt] US ['ɪŋkrəmənt]
• n. [inani] ukwanda, ukwanda, ukwanda, intsalela, ukwanda

Kutheni "auto_increment column inexabiso 0" ivela?

Oku kungenxa yokuba, kusenokubakho enye okanye ngaphezulu kwezi:Indawo eyongezelekayo ngokuzenzekelayo enexabiso elingu-0.

• Chen Weiliangufumene ukusetyenziswa okuninziIwebhusayithi yeWordPressyenzaseoUmhlobo wam naye wayenengxaki efanayo.

Ukulungisa njani?

Oku kulandelayoMySQLIndlela yokulungisa iingxaki zedatabase ilula kakhulu!

Inyathelo 1:Cofa kwi-database ebuzwayo

Inyathelo 2:Cofa ku-"meta_id" okanye "post_id" ▼

• Emva koko, ukuhlela kuqala ngolandelelwano, phiI-NULL nge-ID engu-0 iya kuhlelwa phezulu.

Inyathelo 3:Cima ikholamu yedatha yendawo ye-0 0 NULL NULL▲

• cima ixabiso loluhlu lwedatha ye-id 0 0 NULL NULL intsimi.

Ekugqibeleni, hlalutya kwaye uvavanye itafile yedatha ye-MySQL kwakhona.

Ndifumanise ukuba impazamo yesilumkiso "isilumkiso Kufunyenwe umqolo apho i-auto_increment column inexabiso elingu-0" ayisabonakali, ingxaki isonjululwe, haha!