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