new line in SQL insert query

Question

I want to use the following statement to add a row in a table named people with one column which is varchar(100)

insert into people values ('a b')

I want to have a new line between a and b.

How to do this?

I tried something like 'a CHAR(13) b' but did not work.

Thanks.

possible duplicate of Adding a line break in MySQL INSERT INTO text — Eric Petroelje
– Eric Petroelje, Commented Apr 24, 2012 at 17:01

Rahul · Accepted Answer · 2012-04-24 17:23:29Z

5

How about

'a ' + CHAR(13) + ' b'

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

answered Apr 24, 2012 at 17:03

rickythefox

6,8697 gold badges44 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

I normally do Cr and Ln: 'a ' + CHAR(13) + CHAR(10) + ' b'

Community · Accepted Answer · 2017-05-23 11:49:05Z

1

This works as well:

'a' +  CRLF + 'b'

Check this link as well

CommunityBot

11 silver badge

answered Apr 24, 2012 at 17:22

Rahul

78.1k14 gold badges80 silver badges132 bronze badges