- Home
- Interview Questions
- MySQL
31.
How do I find out all databases starting with ‘tech’ to which I have access to?
SHOW DATABASES LIKE ‘tech%’;
32.
How do you concatenate strings in MySQL?
CONCAT (string1, string2, string3)
33.
How do you get a portion of a string?
SELECT SUBSTR(title, 1, 10) from techpreparation_questions;
34.
What’s the difference between CHAR_LENGTH and LENGTH?
The first is, naturally, the character count. The second is byte count. For the Latin characters the numbers are the same, but they’re not the same for Unicode and other encodings.
35.
How do you convert a string to UTF-8?
SELECT (techpreparation_question USING utf8);
|
|
||||||||||||||||||||||||||||
