Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
documentation:howto:hsqldb [2017/01/30 17:10]
127.0.0.1 external edit
documentation:howto:hsqldb [2018/05/23 16:25] (current)
nqb Run sql queries
Line 76: Line 76:
  
 <note tip>You can specify the table name after the ''​--drop''​ option.</​note>​ <note tip>You can specify the table name after the ''​--drop''​ option.</​note>​
 +
 +===== Run SQL queries =====
 +
 +You can run SQL queries on HSQLDB database :
 +<code bash># Generic (see lsc-sample in doc)
 +$ "​${JAVA_COMMAND}"​ -jar "​$HSQLDB_LIB"​ --rcFile "​$HSQLDB_RC"​ --sql "​YOUR_SQL_QUERY"​ lscdb
 +
 +# Debian
 +$ java -jar /​usr/​lib/​lsc/​hsqldb-VERSION.jar --rcFile /​var/​lsc/​hsqldb/​hsqldb.rc --sql '​YOUR_SQL_QUERY'​ lscdb
 +</​code>​
 +
 +<note important>​Don'​t forget '';''​ at end of SQL query</​note>​
 +
 +