is there a way to show the columns and thier datatypes a apge at a time? what i mean is, say there are 37 columns, and u use the command:
SHOW COLUMNS FROM tableX;
the columns and thier data types are shown but they scroll up the screen too fast and i can only see the last 20 columns and thier data types. so is there an extension to the show columns command so it shows a page at a time (ie. like the "| more" command in unix)???
thanks in advance!!!