How to modify the MySQL field to capitalize the first letter

The method of modifying the first letter of the MySQL field: first use LEFT to take out the first letter alone and use UPPER to replace it with uppercase; then determine the length of the field, and use SBUSTRING to take out all the fields from the second to the end for backup; then Use CONCAT to connect the two values ​​above; finally, modify the value of the update table field.

The above is the detailed content of how to modify the MySQL field to capitalize the first letter. For more information, please pay attention to other related articles on 1024programmer.com!