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?
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=arch...@jab.org
