Output inserterd MariaDB

OL Connect Professional Workflow
1

Hi,

I have made my application in MS SQL, but I want to change it to MariaDB.

Does anyone know how to write to current sql statement for MariaDB?

INSERT INTO customer_data (email, first, affix, last)
OUTPUT INSERTED.uid, INSERTED.salt, INSERTED.websalt
VALUES (‘%{userName}’, ‘%{firstName}’, ‘%{affix}’, ‘%{lastName}’)

thank you in advance!

Koen

2

MariaDB and MySQL do not support the OUTPUT clause. If you google for it, you will find a few different workarounds, but they all seem to be clunky at best.

3

hi Phil,

thank you for your response, I know I found them too.

I’ll continue my search.