RE: Some MySQL questions

2009-10-08 Thread Gavin Towey
Try the tutorial: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Regards, Gavin Towey -Original Message- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Thursday, October 08, 2009 2:19 PM To: mysql@lists.mysql.com Subject: Some MySQL questions 1) When I select * from wha

Re: Some MySQL questions

2009-10-08 Thread Nathan Sullivan
On Thu, Oct 08, 2009 at 02:33:34PM -0700, Carlos Proal wrote: > On 10/8/2009 4:19 PM, John Oliver wrote: > > 1) When I select * from whatever; is there a way to have the results go > > by one screen at a time? > > > > You can limit output by delimiting your search ie > > select * from users li

Re: Some MySQL questions

2009-10-08 Thread Carlos Proal
On 10/8/2009 4:19 PM, John Oliver wrote: 1) When I select * from whatever; is there a way to have the results go by one screen at a time? You can limit output by delimiting your search ie select * from users limit x,y; x=offset y=rows after the ofset 2) In reference to the above, is ther