MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL

What is the difference between BLOB AND TEXT?

A BLOB is a binary large object that can hold a variable amount of data. There are four types of BLOB in MySQL, they are as follows,

  1. TINYBLOB
  2. BLOB
  3. MEDIUMBLOB
  4. LONGBLOB

They all differ only in the maximum length of the values they can hold.

A TEXT is a case-insensitive BLOB. The four TEXT types

  1. TINYTEXT
  2. TEXT
  3. MEDIUMTEXT
  4. LONGTEXT

They all correspond to the four BLOB types and have the same maximum lengths and storage requirements.
The only difference between BLOB and TEXT types is that sorting and comparison are performed in case-sensitive for BLOB values and case-insensitive for TEXT values.




Next 5 interview question(s)

1
Is Mysql query case sensitive?
2
How can you see all indexes defined for a table?
3
How do you login to MySql using Unix shell?
4
What is the difference between primary key and candidate key?
5
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?