MEMORY tables do not support BLOB and TEXT indexes. 

  MEMORY tables do not support BLOB and TEXT indexes. 

What is the join called which produces all possible row combinations?

Which command is used to redefined the mysql delimiter? 

On UNIX, statements entered in ‘MySQL’ are saved in which file? 

What is 'student' in the following SQL statement?

SELECT student FROM xyz;

  The “Mysql command line tool” format the results in which of the following format: 

SELECT CONCAT('SQL', ' is', ' fun!');

Choose the correct option mentioned below.

  Which one is the correct declaration for choosing the character set other than default? 

What will be the output of the following query?

 SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;