[gameprogrammer] Slightly offtopic: SQL Command
- From: Kevin Jenkins <gameprogrammer@xxxxxxxxxx>
- To: gameprogrammer@xxxxxxxxxxxxx
- Date: Mon, 30 Oct 2006 17:15:04 -0800
If I use the SQL command INSERT to insert a row into a table which has
a primary key with the serial property, to automatically generate a
per-row unique ID, how do I get the ID of the thing I just inserted?
Should I immediately query for the newest ID?
---------------------
To unsubscribe go to http://gameprogrammer.com/mailinglist.html
- Follow-Ups:
- [gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Jake Briggs
- [gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Matthew Weigel
- References:
- [gameprogrammer] Gaming industry - how prevalent?
- From: Alan Wolfe
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Casey O'Donnell
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Alan Wolfe
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Agha Usman Ahmed
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Chris Nystrom
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Enrico Zschemisch
Other related posts:
- » [gameprogrammer] Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- » [gameprogrammer] Re: Slightly offtopic: SQL Command
- [gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Jake Briggs
- [gameprogrammer] Re: Slightly offtopic: SQL Command
- From: Matthew Weigel
- [gameprogrammer] Gaming industry - how prevalent?
- From: Alan Wolfe
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Casey O'Donnell
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Alan Wolfe
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Agha Usman Ahmed
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Chris Nystrom
- [gameprogrammer] Re: Gaming industry - how prevalent?
- From: Enrico Zschemisch