[MonetDB-users] last inserted id
25 Jun
2012
25 Jun
'12
7: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
12: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
4626
Age (days ago)
4627
Last active (days ago)
1 comments
2 participants
participants (2)
-
Fabian Groffen -
Tomas Mikula