Yog tias koj siv cov ntaub ntawv nrog cov ntawv qis dua MySQL 8.0,
koj yuav tau txais WordPress 6.5 sai thaum lub chaw kuaj mob: ”
Old SQL Server ” Vim li cas WordPress thiaj pom zoo MySQL 8.0 lossis siab dua?
Kab lus no qhia txog qee qhov tshiab thiab kev txhim kho kev ua haujlwm coj los ntawm MySQL 8.
Cov ntsiab lus index
Cov yam ntxwv tshiab thiab kev txhim kho kev ua tau zoo ntawm MySQL 8 piv rau MySQL 5.7
Kev them nyiaj yug JSON
Cov cim cim thiab collations
Qhov rai muaj xov tooj library nuj nqi
CTE (common table expression)
Authentication plugin
Kev txhim kho kev ua haujlwm Vim li cas WordPress
MySQL 8 kev txhim kho tshwj xeeb rau WordPress cov vev xaib
Kev ua tau zoo tshaj plaws
Txhim khu kev ruaj ntseg.
Kev them nyiaj yug JSON
Ntau tus cwj pwm teeb tsa txhawb nqa
Cov lus nug nplua nuj ua haujlwm
Cov ntsiab lus
Yam ntxwv tshiab thiab kev txhim kho kev alibaba huab, tencent cloud thiab jd huab: kev sib piv ntawm tus nqi tshwj xeeb ua tau zoo ntawm MySQL 8 piv rau MySQL 5.7
Kev them nyiaj yug JSON
MySQL 8 : Qhia txog JSON ua tiav ntau dua, suav nrog JSON cov ntaub ntawv hom thiab ntau yam
JSON kev ua haujlwm, ua rau kev ua haujlwm thiab nug JSON cov ntaub ntawv zoo dua.
MySQL 5.7 : Txawm hais tias nws kuj Vim li cas WordPress txhawb JSON cov ntaub ntawv,
nws cov haujlwm kuj yooj yim piv rau MySQL 8.
Cov cim cim thiab collations
MySQL 8 : Txhawb ntau tus cwj pwm thiab kev sib koom ua ke,
suav nrog UTF8MB4 tus cwj pwm teeb tsa raws li lub cim ua ntej, thiab txhawb ntau hom lus thiab cov cim.
MySQL 5.7 : Lub neej ua cim teeb yog UTF8 tsis yog UTF8MB4,
thiab cov cim txhawb nqa thiab kev sib koom ua ke yog tsawg.
Qhov rai muaj nuj nqi
MySQL 8 : Qhia txog qhov rais ua cov ntaub ntawv twv txiaj haujlwm (Qhov rai Functions),
xws li ROW_NUMBER(), RANK(), DENSE_RANK(), thiab lwm yam,
ua rau cov ntaub ntawv txheeb xyuas thiab Vim li cas WordPress ua kom yooj yim dua.
MySQL 5.7 : Qhov rai ua haujlwm tsis tau txais kev txhawb
nqa thiab cov lus nug SQL nyuaj yuav tsum ua kom tiav cov haujlwm zoo sib xws.