Select Code to Download

        my $rval = '';
        my $sth2 = $dbh->prepare("SHOW COLUMNS FROM $table");
...
            while ( my @arr = $sth2->fetchrow_arrayref() )
                { $rval .= '[' . join('|', @arr ) . ']'; }
            }

mysql> show columns from cmsParms;
+--------+-----------+------+-----+---------+-------+
...
| pValue | text      | NO   |     | NULL    |       |
+--------+-----------+------+-----+---------+-------+
2 rows in set (0.01 sec)