bad mysql output
By kamil... on March 06, 2012 09:04 (imported from Google Code)
Hi,
I have a problem, i don't know what is wrong.
Login by ssh to linux host and
# mysql -u root -p
# USE some table;
# SELECT * FROM some table;
gives me scratched output, i mean, some rows that have probably new line characters are scratching output which looks like below:
mysql> SELECT * FROM przebieg;
+------+------------+---------------------+-------+-----------+-------------------+------------+
| id | id_zadania | kiedy | flaga | aktywnosc | opis | uzytkownik |
+------+------------+---------------------+-------+-----------+-------------------+------------+
| 2980 | 465 | 2012-03-05 21:20:07 | 1 | 1 | | 0 |
| 2979 | 467 | 2012-03-05 21:20:07 | 1 | 1 | | 0 |
| 2978 | 466 | 2012-03-05 21:20:07 | 1 | 1 | | 0 |
| 2977 | 462 | 2012-03-05 21:20:07 | 1 | 1 | | 0 |
| 2976 | 468 | 2012-03-05 21:20:07 | 1 | 1 | | 0 |
| 2975 | 469 | 2012-03-05 21:20:07 | 1 | 1 | | 0 |
| 2974 | 466 | 2012-03-05 21:20:07 | 1 | 1 | | 0 |
| 2972 | 464 | 2012-03-04 15:31:36 | 4 | 2 | | 1 |
| 2970 | 466 | 2012-03-04 13:50:46 | 4 | 2 | | 1 |
| 2969 | 469 | 2012-03-02 17:27:16 | 1 | 2 | | 1 |
| 2966 | 463 | 2012-03-01 15:05:42 | 5 | 1 | | 1 |
| 2964 | 462 | 2012-03-01 01:04:04 | 3 | 0 | 9:15 | 1 |
| 2963 | 462 | 2012-03-01 01:03:53 | 3 | 0 | 10:00 | 1 |
| 2962 | 462 | 2012-03-01 01:02:53 | 3 | 0 | 08:45 | 1 |
test2 | 1 || 2012-03-01 00:27:42 | 2 | 0 | test2
test3 | 1 || 2012-03-01 00:27:37 | 2 | 0 | test2
test2 | 1 |-03-01 00:26:11 | 2 | 0 | test2
test2 | 1 |-03-01 00:25:57 | 2 | 0 | test2
test2 | 1 || 2012-03-01 00:24:33 | 2 | 0 | test2
test2 | 1 || 2012-03-01 00:22:11 | 2 | 0 | test2
test2 | 1 |-03-01 00:20:12 | 2 | 0 | test2
| 2953 | 462 | 2012-03-01 00:16:50 | 2 | 0 | test2 | 1 |
| 2952 | 462 | 2012-03-01 00:13:14 | 2 | 0 | test | 1 |
| 2951 | 462 | 2012-03-01 00:12:26 | 2 | 0 | test | 1 |
| 2950 | 462 | 2012-03-01 00:10:45 | 2 | 0 | test | 1 |
| 2949 | 462 | 2012-03-01 00:09:31 | 2 | 0 | test | 1 |
| 2948 | 462 | 2012-03-01 00:08:11 | 2 | 0 | test | 1 |
| 2947 | 462 | 2012-03-01 00:06:35 | 2 | 0 | test | 1 |
This issue not exist when doing this from linux terminal.
Thanks for response,
iTerm2, Build 1.0.0.20120203
Mac OSX Lion 10.7.3 (up to date)
Cheers,
Kamil