[MonetDB-users] last inserted id
25 Jun
2012
25 Jun
'12
9:09 p.m.
Hi,
how can I get the ID (value of an AUTO_INCREMENT column) of the last inserted row, from within an SQL script? I am able to get it through the Python API, so I suppose there is a way to get it inside an SQL script, too.
Thanks, Tomas
26 Jun
26 Jun
2:17 a.m.
On 25-06-2012 15:09:44 -0400, Tomas Mikula wrote:
Hi,
how can I get the ID (value of an AUTO_INCREMENT column) of the last inserted row, from within an SQL script? I am able to get it through the Python API, so I suppose there is a way to get it inside an SQL script, too.
IF you script is interfacing with mclient, it has to parse it's output (use -i) which reports "last generated id".
Fabian
4328
Age (days ago)
4329
Last active (days ago)
1 comments
2 participants
participants (2)
-
Fabian Groffen
-
Tomas Mikula