Re: select first or last row

2002-04-20 Thread Fournier Jocelyn [Presence-PC]
lt;[EMAIL PROTECTED]> Sent: Sunday, April 21, 2002 4:50 AM Subject: select first or last row > Hi > > MySql Details My server is running MySQL 3.23.45 and I have > 4.0.0-alpha-nt on my local test machine. > > > > What is the fastest way to select the first or the last r

select first or last row

2002-04-20 Thread webmaster
Hi MySql Details My server is running MySQL 3.23.45 and I have 4.0.0-alpha-nt on my local test machine. What is the fastest way to select the first or the last row from a database? I have tried queries like this (id is an auto incrementing primary key) select * from names order by id de