jMySQLCli

jmysqlcli is a simple command line client to query a mysql server, free as beer and open source (Apache License, Version 2.0).

---

DOC

Requirements, Installation and Running

• Java Runtime (8 o newer): https://jdk.java.net/java-se-ri/17
• This software run in Portable Mode, you only need copy jar file in a folder to run.

Usage Example (command line)

java -Djmysqlcli.verbose=true -Djmysqlcli.config=/opt/jmysqlcli/config.properties -jar /opt/jmysqlcli/jmysqlcli-x.x.x.jar

Config file example (properties):

# JDBC Connection URL
url=jdbc:mysql://localhost/test?user=test&password=test
# Method 1, The query statement (only select allowed)
query=SELECT 'OK' AS TEST
# Method 2, A list of SQL statements (select, update, delete, etc), the order is 1-based; followed by 2, and so on.
sql.1=SELECT 'OK' AS TEST
sql.2=SELECT 'GOOD' AS TEST
# default is show header row
#header.wanted=true
# default value is semicolon
#column.separator=;
# default value is LF
#row.separator=\n

References:

• JDBC Connection URL syntax
• Query statement syntax
• SQL statement syntax

---

Inspired in mysql-client and sqlline, this is a Java-minimalistic version.