DATABASE | MYSQL | MYSQL INTERVIEW QUESTION AND ANSWERS 4 | IF THE VALUE IN THE COLUMN IS REPEATABLE, HOW DO YOU FIND OUT THE UNIQUE VALUES? | EXPLAIN THE DIFFERENCE BETWEEN FLOAT, DOUBLE AND REAL? | HOW DO YOU GET THE CURRENT VERSION OF MYSQL? | IS MYSQL QUERY HAS LETTERCASE? | WHAT IS THE LIKE?

Mysql Interview Question and Answers:

16.     If the value in the column is repeatable, how do you find out the unique values?
      SELECT DISTINCT user_firstname FROM users;

17.     Explain the difference between FLOAT, DOUBLE and REAL?
      FLOATs store floating point numbers with 8 place accuracy and take up 4 bytes. DOUBLEs store floating point numbers with 16 place accuracy and take up 8 bytes. REAL is a synonym of FLOAT for now.

18.     How do you get the current version of mysql?
      SELECT VERSION();

19.     Is Mysql query has LETTERCASE?
      No.
Ex :
SELECT VERSION(), CURRENT_DATE;
select version(), current_date;
SeLeCt vErSiOn(), current_DATE;

20.     What is the LIKE?
      A LIKE pattern match, which succeeds only if the pattern matches the entire value.