Explain the difference between BOOL, TINYINT and BIT?
- 1 Answers
- 5405 Views
- I also Faced
- E-Mail Answers
Explain the difference between BOOL, TINYINT and BIT?..
Answer / amith
Prior to MySQL 5.0.3: those are all synonyms. After MySQL
5.0.3: BIT data type can store 8 bytes of data and should
be used for binary data.
| Is This Answer Correct ? | 5 Yes | 0 No |
More MySQL Interview Questions
What is the limit of mysql database?
What are triggers mysql?
Does mysql use tcp or udp?
How to determine the location of the data directory?
Differentiate CHAR_LENGTH and LENGTH?
Is mysqli deprecated?
How we can get the current date in mysql?
What is truncate command?
What is a delimiter in mysql?
What are the advantages and disadvantages of using mysql?
What is a table schema?
Is mysql distributed?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
