mercredi 11 mars 2015

Limit columns to certain width in `mysql` command


The mysql command gives nice tabular outputs that take into consideration half and full width spacing.


For example:



> select 'The quick brown fox jumps over the' text union select '01234567890';
+------------------------------------+
| text |
+------------------------------------+
| The quick brown fox jumps over the |
| 01234567890 |
+------------------------------------+
2 rows in set


Given this, how do I truncate a column to a certain width?


e.g. How do I get this?



+----------------+
| text |
+----------------+
| The quick brow |
| 0123456 |
+----------------+




Aucun commentaire:

Enregistrer un commentaire