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:
No, there is no such option.
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
-- 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/[EMAIL PROTECTED]