How to represent ENUMs and SETs internally?
Answer / Rishi Kant Misra
In MySQL, ENUMs (enumerated data types) are represented as a tinyint with a specific value range assigned to each enumerated constant. SETs are represented using bitwise operations. Internal representation is beyond the scope of this response.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is mysql connect deprecated?
What is mysql in linux?
What are some good ideas regarding user security in MySQL?
How to make a copy values from one column to another in mysql?
Can python connect to mysql?
How do I run a query in mysql?
How many tables we can create in mysql database?
What is the difference between CHAR and VARCHAR data types?
What is blob and clob?
What is required to create mysql database?
Is primary key auto increment?
What is procedures in mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)