Comments can be written in a single line or multiple lines. We can use MySQL single-line comments in two ways, either by using or. MySQL generally ignores them during the parsing of the SQL code.
It is used for the purpose of making the SQL statements easier for humans to understand. (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. A comment is a readable explanation or a statement placed in the SQL queries. MySQL Tryit Editor v1.0 Get your own SQL server SQL Statement: x - Select all: SELECT FROM Customers Edit the SQL Statement, and click 'Run SQL' to see the result. (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'), sql file loaded by liquibase: INSERT INTO user (id,firstname,lastname,mystring) VALUES The opening and terminating characters need not be separated from the. 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. End the comment with an asterisk and a slash (/). I am working with liquibase and a hsqldb database.
0 kommentar(er)
