MySQL database small common sense

1. Remove the space in the middle of the value of a field in MySQL data

Update TableName

Set column name =replace (column name, Space, ')

Where column name like '% '

Update student Set Sname=replace (sname, ', ') where sname like '% '

The replacement function replace (column name, FROM_STR,TO_STR) is used here, and the value of the field name is converted from FROM_STR to To_str

2. Remove the space after a field in the MySQL database

Update TableName

Set column name =trim (column name)

Update student set Sname=trim (sname)

　　

MySQL database small common sense