MySQL Interview Questions and Answers Part-5
41. How MySQL Optimizes DISTINCT? DISTINCT is converted to a GROUP BY on all columns and it will be combined with ORDER BY clause. SELECT DISTINCT t1.a FROM t1,t2 where t1.a=t2.a;
Read MoreMySQL Interview Questions and Answers Part-4
31. How can we get the number of rows affected by query? Number of rows can be obtained by SELECT COUNT (user_id) FROM users;
Read MoreMySQL Interview Questions and Answers Part-3
21. How do you control the max size of a HEAP table? Maximum size of Heal table can be controlled by MySQL config variable called max_heap_table_size. 22. What is the difference between MyISAM Static and MyISAM Dynamic? In MyISAM static…
Read MoreMySQL Interview Questions and Answers Part-2
11. Define REGEXP? REGEXP is a pattern match in which matches pattern anywhere in the search value. 12. Difference between CHAR and VARCHAR? Following are the differences between CHAR and VARCHAR:
Read MoreMySQL Interview Questions and Answers Part-1
1. What is MySQL? MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle)
Read More