![]() ![]() Lets look at a SQL comment example that shows a SQL comment that is on a single line and does not span multiple lines. (12,'Kirsten','Parker','this is the string of Kristen')Ĭaused by: 圎rrorException: unexpected token: KIRSTEN required: ) : line: 12Īt .sqlException(Unknown Source)Īt .fetchResult(Unknown Source)Īt .execute(Unknown Source)Īt .DelegatingStatement.execute(DelegatingStatement.java:264)Īt $1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)Īt .execute(JdbcExecutor. You can create a SQL comment on a single line in your SQL statement in SQLite. (12,'Kirsten','Parker','this is the string of Kirsten')Īnd my stacktrace: : Error executing SQL INSERT INTO user (id,firstname,lastname,mystring) VALUES (11,'Wendy','Salinas','this is my string-and it continues'), This is single-line comment.- This is also single-line comment. Multi-line comments or single-line or end-of-line comment. Example : SELECT 2+4, CURDATE() Output : 8. sql file loaded by liquibase: INSERT INTO user (id,firstname,lastname,mystring) VALUES SELECT can also be used for more than one or many columns. sql file with 'insert' instructions for filling the database at the bootstrap, but if a string contains two minus signs close to each other it is interpreted as a comment and not as string. I am working with liquibase and a hsqldb database. ![]()
0 Comments
Leave a Reply. |