MySQL field at the beginning of the space how to clear

：

Name field, a space is added in front of the data you put in (PS, the first few data I manually modified). This affects the subsequent lookups. The INSERT statement I used is:

Insert into User (Name,password,email,create_time) VALUES (' $name ', ' $password ', ' $email ', ' $time ')

Where the field name is in the form varchar (45). There are two ways to end the Web, the first is to use the PHP str_replace function to clear spaces and special characters, and then still add space.

The second is the use of the MySQL statement trim, will still add space.

Later I immediately replaced the $name with a string, found the space.

So I think it should be the internal MySQL thing, tracking here will not go on. I hope someone can answer them.

Reply content:

：

Name field, a space is added in front of the data you put in (PS, the first few data I manually modified). This affects the subsequent lookups. The INSERT statement I used is:

Insert into User (Name,password,email,create_time) VALUES (' $name ', ' $password ', ' $email ', ' $time ')

Where the field name is in the form varchar (45). There are two ways to end the Web, the first is to use the PHP str_replace function to clear spaces and special characters, and then still add space.

The second is the use of the MySQL statement trim, will still add space.

Later I immediately replaced the $name with a string, found the space.

So I think it should be the internal MySQL thing, tracking here will not go on. I hope someone can answer them.

There is also a varchar type field in front of name, which can be deleted. Unknown so ~ ~ ~

You need to give a look at the definition of the table ...

