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 limit x,y; > > x=offset > y=rows after the ofset > > > 2) In reference to the above, is there a way to just display the row > > that shows the names of each column? > > >
You can also use a pager. On my Linux system I can type 'pager less' to use the less program to page through the results. Just type 'pager' to turn go back to normal. > I guess you are talking about describe to show table attributes > > describe users; > > > I need to drop one row from a table with a few thousand rows. I > > guessing I want to: > > > > delete from 'users' where <COLUMN_NAME> = 1898; > > > > Is that right? I'm not sure if COLUMN_NAME is "uid" or "id" or maye > > something else, and since I can't pipe it through more or less... :-) > > > > > > > Carlos > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=nsulli...@cappex.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
