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

Let's talk about the line wrapping method of mysql. The secret of the text is to be close to the topic. So, no more gossip, let's go straight to the following, I believe you will benefit from reading this article on mysql line breaking.

Do you have such doubts during the operation of mysql? I don't know how to wrap lines in mysql. In fact, line wrapping can be easily achieved as long as you enter a newline command statement in mysql.

Newline statement:

UPDATE table name SET field = REPLACE (REPLACE (field, CHAR (10),''), CHAR (13),'')

Note:

CHAR (10): newline character

CHAR (13): carriage return

Is there anything you don't understand about the above mysql line wrapping method? Or if you want to know more about it, you can continue to follow our industry information section.

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.