Hi all,
following query
SELECT LAST_INSERT_ID() as auto_num FROM xrenders;
fills our whole slow query log (500 kB a day).
AUTO_INCREMENT field is int(11) type, primary key;
table is of type MyISAM.
We do the same operation on another similar table of the same
db which is much larger without
On Fri, Jan 25, 2002 at 02:22:12PM +0100, Marek Kustka wrote:
following query
SELECT LAST_INSERT_ID() as auto_num FROM xrenders;
fills our whole slow query log (500 kB a day).
Just do 'select last_insert_id() as auto_num'.
The id isn't kept per table anyway, it is kept per session.
Fred van Engen wrote:
On Fri, Jan 25, 2002 at 02:22:12PM +0100, Marek Kustka wrote:
following query
SELECT LAST_INSERT_ID() as auto_num FROM xrenders;
fills our whole slow query log (500 kB a day).
Just do 'select last_insert_id() as auto_num'.
The id isn't kept per table anyway, it