How to enter new line using sql command INSERT

Question

Q:

I wanna to know the syntax of SQL query of inserting new line in my table.

I mean ,I wanna to enter the following in my table abc:

  aaaaaaaaaa

  bbbbbbbbbb

  cccccccccccc

Maintaining the new line.through INSERT command .

Thanks in advance

Usually, the best way to deal with that is with a placeholder '?' in the SQL and pass the value via a host variable when the statement is executed. This method also avoids SQL injection attacks. Failing that, the `ifx_allow_newline()` function is the way to go. — Jonathan Leffler, Sep 12 '11 at 19:04

Richard · Accepted Answer · 2011-09-11T10:47:38.553

When I answered this question, you'd got it tagged with SQL Server 2008. You've since edited it to be about Informix. The following works for SQL Server 2008.

INSERT INTO MyTable(MyField) VALUES('AAAAA' + CHAR(13) + CHAR(10) + 'BBBBB')

Informix looks more complicated. You have to set an option according to this documentation I found with a google for "informix sql newline"

EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('T')

score 2 · Answer 2 · answered Sep 11 '11 at 10:03

2

Never used informix but for SQL Server 2008 this is just.

INSERT INTO abc
            (col1)
VALUES (
'aaaaaaaaaa

bbbbbbbbbb

cccccccccccc');

answered Sep 11 '11 at 10:03

Martin Smith

438,706
87
741
845

mmmm , thanks this doesn't work with informix, `Found a quote for which there is no matching quote` – Anyname Donotcare Sep 11 '11 at 10:08
2

Someone else will have to supply the `Informix` end of things! – Martin Smith Sep 11 '11 at 10:10

score 2 · Answer 3 · answered Sep 11 '11 at 10:04

2

INSERT INTO MyTable(MyColumn) VALUES ('aaaaaaaaaa

bbbbbbbbbb

cccccccccccc');

answered Sep 11 '11 at 10:04

ta.speot.is

26,914
8
68
96

mmmm , thanks this doesn't work with informix, `Found a quote for which there is no matching quote` – Anyname Donotcare Sep 11 '11 at 10:10

score 1 · Answer 4 · edited May 23 '17 at 12:25

1

It depends whether you're using Windows or *nix conventions, but it will be some combination of \r and \n

Have a look at the New line in Sql Query question.

edited May 23 '17 at 12:25

Community

1
1

answered Sep 11 '11 at 09:50

David

844
6
14

Good information,thanks alot .this is about how to get.but my question is about How to insert? – Anyname Donotcare Sep 11 '11 at 09:54

score 1 · Answer 5 · answered Sep 12 '11 at 06:41

1

why not store the row without the newline, then on the client side of your app, provide for it?

answered Sep 12 '11 at 06:41

Joe R.

2,032
4
36
72

How to enter new line using sql command INSERT

5 Answers5

Linked