Through Phpmyadmin added a new field with type ENUM to the table structure with a rather large number of elements. 4 not particularly long values. Also set one of them as default.

There were two problems:

  1. Phpmyadmin no longer displays the structure of this table in acc. tab. It is as if a click on a tab is ignored, but does not freeze.
  2. Attempts to make changes to the fields in this table are unsuccessful. There are no errors, but the values ​​do not change.

With the table, everything was fine before, the data were installed and obtained quickly. The point is in the ENUM . removing it through DROP COLUMN I get a worksheet.

I thought ENUM is an economical type and doesn’t load the database very hard?

  • The problem is most likely in phpmyadmin, look at its logs or check the work with another tool - Stranger in the Q
  • And there is a good replacement for ENUM - user64675

1 answer 1

I highly recommend using ENUM in MySQL. It is better to store these fields as integers. To store the values ​​you can create a separate page. Also adding new values ​​to ENUM will result in an alter table.