Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to remove r n in mysql table, which has certain reference value, and friends who need it can refer to it. I hope you all have a lot of success after reading this article. Let's take a look at it together.

Methods to remove r n in mysql table: 1. Use " replace(field name,char(13),'')" method to remove carriage return "r";2. Remove newline "n" by "replace(field name,char(10),'')" method.

When displaying data, it is inevitable to encounter data content with carriage returns, newlines, you can use the replace function to remove:

1. Remove the carriage return

replace(field name,char(13),'')

2. Remove the newline

replace(field name,char(10),'')

3. Remove the carriage return character.

replace(field name,char(13)+char(10),'')

ASCII code table attached:

Thank you for reading this article carefully. I hope Xiaobian can share how to remove the r n content in mysql table to help everyone. At the same time, I hope everyone will support you a lot. Pay attention to the industry information channel. When you encounter problems, find detailed solutions waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.