Execution Python version

./msql_query "<sql_host>" "<sql_port>" "<sql_user>" "<sql_password>" "<sql_database>" "<sql_query>" ["<delimiter_character>"]


<sql_host>
SQL ServerHost\Instance to connect.
<sql_port>
Sql port
<sql_user>
Database connection Domain\User.
<sql_password>
Database connection password.
<sql_database>
Database name.
<sql_query>
SQL query to get the value. Strings in WHERE statement must use single quotes..
<delimiter_character>
Optional. Field delimiter character of the SQL query result. By default it uses “,”

Example:

./msql_query "SQLSERVER\INSTANCE1" "artica" "pandora" "pandora_database" "select * from tdata where value=’monitoring’" "|"

Revision #3
Created 13 September 2021 09:32:10 by alvaro.tejerina
Updated 24 May 2023 13:10:18 by alejandro.sanchez