While watching a realtime data acquistion system's MySQL table fill, I
routinely run "mysql> SELECT * FROM TABLE". After 300+ rows scroll by [in
text mode under *nix], I've usually lost track of which column [out of
23] belongs to what datafield.

Is there an option to have the "mysql" tool repeat the column headings
provided at the beginning of select after the last row? At the moment,
I use:

mysql> select * from en; select * from en order by date desc,hour desc,minute desc limit 1;

but the column widths do not match up [due to 0s where NNNN might have
existed eariler].

TIA


--
email filters only allow mysql mailing list email, no direct replies or queries

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

At 11:30 -0700 7/22/03, MySQL wrote:
No, there is no such option.


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw