INSERT INTO MyTable VALUES('Hello
world');

Alternatively, construct the string dynamically:

INSERT INTO MyTable VALUES('Hello' || char(10) || 'world');

(The type of newline (13 or 10 or 13+10) is OS dependent.)

When you embed the SQL statements in C++ strings, you have to escape the newline in the first case:

q1 = "INSERT INTO MyTable VALUES('Hello\nworld');";
q2 = "INSERT INTO MyTable VALUES('Hello' || char(10) || 'world');";


'Spring > JPA' 카테고리의 다른 글

Sqlite Insert into 시 value에 개행문자 처리  (0) 2017.12.20
JPA QueryDSL 참조  (0) 2017.09.06
Spring data jpa 설명  (0) 2017.09.05
JPA 쿼리 이것저것  (0) 2017.08.28
JPA query keywords  (0) 2017.08.28

http://adrenal.tistory.com/25

'Spring > JPA' 카테고리의 다른 글

Sqlite Insert into 시 value에 개행문자 처리  (0) 2017.12.20
JPA QueryDSL 참조  (0) 2017.09.06
Spring data jpa 설명  (0) 2017.09.05
JPA 쿼리 이것저것  (0) 2017.08.28
JPA query keywords  (0) 2017.08.28

http://arahansa.github.io/docs_spring/jpa.html

'Spring > JPA' 카테고리의 다른 글

Sqlite Insert into 시 value에 개행문자 처리  (0) 2017.12.20
JPA QueryDSL 참조  (0) 2017.09.06
Spring data jpa 설명  (0) 2017.09.05
JPA 쿼리 이것저것  (0) 2017.08.28
JPA query keywords  (0) 2017.08.28

http://liveupdate.tistory.com/248

'Spring > JPA' 카테고리의 다른 글

Sqlite Insert into 시 value에 개행문자 처리  (0) 2017.12.20
JPA QueryDSL 참조  (0) 2017.09.06
Spring data jpa 설명  (0) 2017.09.05
JPA 쿼리 이것저것  (0) 2017.08.28
JPA query keywords  (0) 2017.08.28

Appendix C: Repository query keywords

Supported query keywords

The following table lists the keywords generally supported by the Spring Data repository query derivation mechanism. However, consult the store-specific documentation for the exact list of supported keywords, because some listed here might not be supported in a particular store.

Table 10. Query keywords
Logical keywordKeyword expressions

AND

And

OR

Or

AFTER

AfterIsAfter

BEFORE

BeforeIsBefore

CONTAINING

ContainingIsContainingContains

BETWEEN

BetweenIsBetween

ENDING_WITH

EndingWithIsEndingWithEndsWith

EXISTS

Exists

FALSE

FalseIsFalse

GREATER_THAN

GreaterThanIsGreaterThan

GREATER_THAN_EQUALS

GreaterThanEqualIsGreaterThanEqual

IN

InIsIn

IS

IsEquals, (or no keyword)

IS_NOT_NULL

NotNullIsNotNull

IS_NULL

NullIsNull

LESS_THAN

LessThanIsLessThan

LESS_THAN_EQUAL

LessThanEqualIsLessThanEqual

LIKE

LikeIsLike

NEAR

NearIsNear

NOT

NotIsNot

NOT_IN

NotInIsNotIn

NOT_LIKE

NotLikeIsNotLike

REGEX

RegexMatchesRegexMatches

STARTING_WITH

StartingWithIsStartingWithStartsWith

TRUE

TrueIsTrue

WITHIN

WithinIsWithin


'Spring > JPA' 카테고리의 다른 글

Sqlite Insert into 시 value에 개행문자 처리  (0) 2017.12.20
JPA QueryDSL 참조  (0) 2017.09.06
Spring data jpa 설명  (0) 2017.09.05
JPA 쿼리 이것저것  (0) 2017.08.28
JPA query keywords  (0) 2017.08.28

+ Recent posts