Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 5
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Dec
6
awarded  Notable Question
Feb
14
awarded  Popular Question
Dec
27
awarded  Autobiographer
Jan
24
comment Is it possible to change ENUM() lists?
I agree ENUMs are strings but internally those are nor stored as strings isn't it?
Jan
24
comment Is it possible to change ENUM() lists?
So internally those are stored as int based on the order in the ENUM(). For instance ENUM('yes', 'no', 'maybe') stores internally 0 for 'yes', 1 for 'no', 2 for 'maybe'. I imagine that the metadata of the table is like ENUM('yes', 'no', 'maybe') instead of ENUM('yes' => 0, 'no' => 1, 'maybe' => 2). Is it true?
Jan
24
awarded  Editor
Jan
24
revised Is it possible to change ENUM() lists?
Deleted wrong stuff.
Jan
24
awarded  Scholar
Jan
24
accepted Is it possible to change ENUM() lists?
Jan
24
awarded  Student
Jan
24
asked Is it possible to change ENUM() lists?