Search code examples
mysqlzshiterm2

MySQL Screwed Up Output

I'm see some very strange outputs from MySQL, and I don't know whether it's my console or my data that's causing this. Here are some screenshots:

enter image description here

enter image description here

enter image description here

Any ideas?

edit:

mysql> describe transformed_step_a1_sfdc_lead_history;
+-------------------+--------------+------+-----+---------+-------+
| Field             | Type         | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| old_value         | varchar(255) | YES  |     | NULL    |       |
| new_value         | varchar(255) | YES  |     | NULL    |       |
+-------------------+--------------+------+-----+---------+-------+

Max

Solution

  • To verify if there is any control characters, you can use -s option, see http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html#option_mysql_raw