title: Truncate column names in SELECT (MySQL client)
body: <p>When I'm looking into new databases to explore what is there, usually I get tables with long column names but short contents, like:</p>
  <pre><code>mysql&gt; select * from Seat limit 2;
  </code></pre>
  <blockquote>
  <p>+---------+---------------------+---------------+------------------+--------------+---------------+--------------+-------------+--------------+-------------+---------+---------+----------+------------+---------------+------------------+-----------+-------------+---------------+-----------------+---------------------+-------------------+-----------------+</p>
  <p>| seat_id | seat_created        | seat_event_id | seat_category_id | seat_user_id | seat_order_id | seat_item_id | seat_row_nr | seat_zone_id | seat_pmp_id | seat_nr | seat_ts | seat_sid | seat_price | seat_discount | seat_discount_id | seat_code | seat_status | seat_sales_id | seat_checked_by | seat_checked_date   | seat_old_order_id | seat_old_status |</p>
  <p>+---------+---------------------+---------------+------------------+--------------+---------------+--------------+-------------+--------------+-------------+---------+---------+----------+------------+---------------+------------------+-----------+-------------+---------------+-----------------+---------------------+-------------------+-----------------+</p>
  <p>|    4897 | 2016-09-01 00:05:54 |           330 |              331 |         NULL |          NULL |         NULL | 0           |         NULL |        NULL | 0       |    NULL | NULL     |       NULL |          0.00 |             NULL | NULL      | free        |          NULL |            NULL | 0000-00-00 00:00:00 |              NULL | NULL            |
  |    4898 | 2016-09-01 00:05:54 |           330 |              331 |         NULL |          NULL |         NULL | 0           |         NULL |        NULL | 0       |    NULL | NULL     |       NULL |          0.00 |             NULL | NULL      | free        |          NULL |            NULL | 0000-00-00 00:00:00 |              NULL | NULL            |</p>
  <p>+---------+---------------------+---------------+------------------+--------------+---------------+--------------+-------------+--------------+-------------+---------+---------+----------+------------+---------------+------------------+-----------+-------------+---------------+-----------------+---------------------+-------------------+-----------------+</p>
  </blockquote>
  <p>Since the length of the header is longer that the contents of each row, I see a unformatted output which is hard to standard, specially when you search for little clues like fields that aren't being used and so on.</p>
  <p>Is there any way to tell mysql client to truncate column names automatically, for example, to 10 characters as maximum? With the first 10 character is usually enough to know which column they refer to.</p>
  <p>Of course I could stablish column aliases for that with <code>AS</code>, but if there's too much columns and you want to do a fast exploration, that would take too long for each table.</p>
  <p>Other solution will be to tell mysql to remove the prefix <code>seat_</code> for each column for example (of course, for each column I would need to change the used prefix).</p>