Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 60 of 81

MySQL Functions — Question 11

Back to all questions
11
Question

Question 4

If Str = "INFORMATICS PRACTICES ...." and Str1 = "... FOR CLASS XI"

Write commands to print the output as 'informatics practices for class xi'

Answer 
SELECT CONCAT(LCASE('INFORMATICS PRACTICES'), ' ', LCASE('FOR CLASS XI'));
Output
+--------------------------------------------------------------------+
| CONCAT(LCASE('INFORMATICS PRACTICES'), ' ', LCASE('FOR CLASS XI')) |
+--------------------------------------------------------------------+
| informatics practices for class xi                                 |
+--------------------------------------------------------------------+