Informatics Practices
To remove the leading and trailing space from data values in a column of MySQL Table, we use
- Left()
- Right()
- Trim()
- Ltrim()
SQL Queries
1 Like
Answer
Trim()
Reason — The TRIM() function removes leading and trailing spaces from a given string. It performs combined functions of LTRIM() and RTRIM().
Answered By
1 Like
Related Questions
What will be returned by the given query ?
SELECT concat("It", "was", "ok");- "It was ok"
- "It wasok"
- "Itwasok"
- "Itwas ok"
Predict the output of the following query :
SELECT LCASE(MONTHNAME('2023-03-05'));- May
- March
- may
- march
What will be returned by the given query ?
SELECT Round(153.669, 2);- 153.6
- 153.66
- 153.67
- 153.7
What will be returned by the given query ?
SELECT Sign(26);- 1
- -1
- 0
- none of these