I am using Mysql 8.0, and something strange happened. I set the 'autoid' as primary key, and a group of keys as unique keys. SHOW CERATE TABLE below I use the
pdi
uimanager
energy
appointment
usability-testing
push
dnn9
sbt-release
snap7
authlib
django-mptt
onion-architecture
sysdba
statusstrip
visual-c++-2019
color-mapping
file-import
azure-configuration
lambdify
master-detail
bitwig-api
game-center-leaderboard
pace.js
sembast
spring-batch-excel
stdbind
authorize.net-webhooks
region-monitoring
dry-validation
viewchildren