Question

A character expression Name contains “hgfgggdddd”. Write a command to pick the following set of characters from it.
(i) First 6 characters.
(ii) From 3rd to 7th character.

Answer 1

Ans. (i) mysql> SELECT LEFT ('try yourself', 3); (ii) mysql> SELECT SUBSTR ('try yourself'. 3. 5):
Answer by sumit das vkv barogolai