Is it convenient to modify data items when there is a lot of data in the mysql enum type?

for example, if the database has a field type of enum ("axiomagementific database"), can you change this field to enum when there are millions of data in the database? will it be slow?

Feb.28,2021

will have an impact,

not to mention your million-level data

A senior asked the same question

before.

" details "


I have tried to add enumerated items in enum under 100w of data to be done instantly. However, it takes a long time to modify or delete enumerated items, and cannot be deleted if the enumerated items have been used.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b2be17-2babf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b2be17-2babf.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?