Get auto-generated ID from INSERT by Slick Plain SQL

Question

I need to get the auto-increment ID generated by MySQL for my INSERT INTO xxx ....

I know I can get the auto-generated ID for the INSERT DML by Slick DSL, as mentioned in the question of Slick 3.0 Insert and then get Auto Increment Value

But is there any simple solution to get the ID with Slick Plain SQL? I mean sqlu""" INSERT INTO xxx """.

Maybe I can perform INSERT & SELECT LAST_INSERT_ID() in a single MySQL transaction to achieve it? But not sure if it's a recommended way.

Is there any single statement solution to ti?

Thanks!

I believe `SELECT LAST_INSERT_ID()` is _the_ way to get the auto incremented value in MySQL. — gregghz, Feb 26 '21 at 17:49
Thanks. Finally I use the way as `(insertTaskAction andThen selectTaskIdAction).transactionally` — user6502167, Mar 12 '21 at 00:26

score 0 · Accepted Answer · answered Mar 12 '21 at 00:28

0

Finally I use the way as (insertTaskAction andThen selectTaskIdAction).transactionally, although transactionally may not quite necessary.

answered Mar 12 '21 at 00:28

user6502167

1 Answers1