How to enter new line using sql command INSERT
Solution 1
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')
Solution 2
Never used informix but for SQL Server 2008 this is just.
INSERT INTO abc
(col1)
VALUES (
'aaaaaaaaaa
bbbbbbbbbb
cccccccccccc');
Solution 3
INSERT INTO MyTable(MyColumn) VALUES ('aaaaaaaaaa
bbbbbbbbbb
cccccccccccc');
Solution 4
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.
Solution 5
why not store the row without the newline, then on the client side of your app, provide for it?
Anyname Donotcare
Updated on June 05, 2022Comments
-
Anyname Donotcare almost 2 years
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