When inserting data in the table:

There was a "empty line" query:

How to get rid of?
The library, bookstores, table name: user

CodePudding user response:

Now add the corresponding line cut in again solved,
There's a better way?

CodePudding user response:

The update out

CodePudding user response:

Update the set XXX yyy=replace (yyy, '\ n...

CodePudding user response:

UPDATE USER SET NAME=REPLACE (REPLACE (REPLACE (REPLACE (REPLACE (NAME, CHAR (9), "), the CHAR (10), ' '), the CHAR (13), ' '), ' ', '), '\ r \ n', ');
Replaces the Spaces, TAB, newline, enter into a ' '