How to find line break and carriage return (\r\n) in MySQL
You are working as MySQL Developer and you need to write a query that should return all the values from column which has carriage return or line break or both of them.
Let's create sample test table with some sample data and then write the query to get the records with line break and carriage return (\r\n).
create table test(id int, name varchar(100));
-- insert some sample data
insert into test
values(1,'Aamir\n'),
(2,'shahzad'),
(3,'Robert\r\n'),
(4, 'This is \n test');
Thanks for sharing this information. I really like your post very much. You have really shared an informative and interesting post with people
ReplyDeleteData Science-Alteryx Training Course in Coimbatore | Online Data Science Course in Coimbatore | Data Science Training in Coimbatore | Best Data Science Training Institute | Data Science Course in Coimbatore Online Data Science Training in Coimbatore | Data Science with python Training Course in Coimbatore | Data Science Traning in saravanampatti