Re: How to select the 10 last items from a table?

2001-01-31 Thread Remco van den Berg
On Wed, Jan 31, 2001 at 08:00:23AM -0600, The Tilghman wrote: > Try sorting in DESCending order. > > SELECT * FROM item ORDER BY id DESC LIMIT 10; > > -Tilghman People, Thanks for all the answers, but the question was: "How to get the last 10 items in incrementing order." Please read threa

Re: How to select the 10 last items from a table?

2001-01-30 Thread Remco van den Berg
... Still no one-query-solution -Remco -- ------------ Remco van den Berg Admin/SO/helpdesk DSE ICQ: 47514668

Re: How to select the 10 last items from a table?

2001-01-30 Thread Remco van den Berg
wrong order. And then query the temporary table to get right order. -Remco -- ---------------- Remco van den Berg Admin/SO/helpdesk DSE ICQ: 475146

Re: C problem

2001-01-26 Thread Remco van den Berg
version of MySQL? Sometimes there exist separate packages for developpers including the header files and libraries. -Remco -- ---------------- Remco van den Berg Admin/SO/helpdesk DSE ICQ: 47

Re: How to use a database from Sun solaris to Linux

2001-01-26 Thread Remco van den Berg
On Fri, Jan 26, 2001 at 01:28:14PM +0100, Legeard Luc wrote: > Hello > > I 'd like migrate my mysql server wich run on a Sunsolaris to a Linux > computer. > I have installed mysql on my linux and it works > Now , i'like to move database from Unix to Linux > A copy database ( *.ISD, *.ISM,*.frm)