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

MySQL Functions — Question 15

Back to all questions
15
Question

Question 15

To remove the leading and trailing space from data values in a column of MySQL Table, we use

  1. Left()
  2. Right()
  3. Trim()
  4. Ltrim()
Answer

Trim()

Reason — The TRIM() function removes leading and trailing spaces from a given string. It performs combined functions of LTRIM() and RTRIM().