Question

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

Options

• Left()

• Right()

• Trim()

• Ltrim()

Answer 1

To remove the leading and trailing space from data values in a column of MySql Table, we use Trim().

Explanation:

The TRIM function removes both leading and following spaces.