I need to create a field in the table that would contain data on whether the user has confirmed the e-mail. Those. perhaps only two options for input - yes and no.

I do not know how best to do in this case. Just make a field and write 0 or 1 to it, or are there any kinds of fields specifically designed for this?

    3 answers 3

    ENUM('значение1','значение2',...)

    Enumeration Enumerated data type A row object can have only one value selected from a given list of values 'значение1', 'значение2', ..., NULL .

    On occupied memory - one byte is used to list up to 255 possible values. That is, in your particular case, 1 bit.

      I use 0/1 flags with tinyint data type.

        For previously known values, ENUM (enumeration) is best suited.