Skip to content

two SQL queries in one click MySQL #32

Open
@exx22

Description

@exx22

Hi,

Is it possible to create a SQL query against the MySQL database so that two queries are executed on one click?
I tried :

[
{
"rawSql" : "INSERT INTO REPORTER.REPORTER_JOURNAL (chrono, userid, servername, serial, serverserial, text1) VALUES (NOW(), '${__user.id}', 'GRAFANA', '$serverserial', '$serverserial', 'Alert Acknowledge by ${__user.login}')",
"format": "table"
},
{
"rawSql" : "UPDATE REPORTER.REPORTER_STATUS SET acknowledged = IF('${__user.login}' IN ('xxx', 'yyy'), '1', acknowledged) WHERE serverserial = '$serverserial'",
"format": "table"
}
]

Br,
M

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions