macubergeek
IS-IT--Management
Hi all
I did a data load from infile to load a bunch of records into a database from a text file. They all loaded ok but I've run into this weird formatting glitch:
mysql> select * from ports where description like "%SQL*Net 1%";
+----------+------+--------------------------+
| Protocol | Port | Description |
+----------+------+--------------------------+
| tcp | 1525 | Oracle SQL*Net 1 legacy |
|udp | 1525 | Oracle SQL*Net 1 legacy
+----------+------+--------------------------+
2 rows in set (0.03 sec)
and
mysql> select * from ports where port = 1525;
+----------+------+-------------------------------------+
| Protocol | Port | Description |
+----------+------+-------------------------------------+
| tcp | 1525 | oracle |
| udp | 1525 | oracle |
| tcp | 1525 | Prospero Directory Service non-priv |
| udp | 1525 | Prospero Directory Service non-priv |
| tcp | 1525 | Oracle SQL*Net 1 legacy |
|1525 | Oracle SQL*Net 1 legacy
+----------+------+-------------------------------------+
Notice the formatting of the last line in each display. I loaded a text file from notepad. What causes this? How do I fix it?
I did a data load from infile to load a bunch of records into a database from a text file. They all loaded ok but I've run into this weird formatting glitch:
mysql> select * from ports where description like "%SQL*Net 1%";
+----------+------+--------------------------+
| Protocol | Port | Description |
+----------+------+--------------------------+
| tcp | 1525 | Oracle SQL*Net 1 legacy |
|udp | 1525 | Oracle SQL*Net 1 legacy
+----------+------+--------------------------+
2 rows in set (0.03 sec)
and
mysql> select * from ports where port = 1525;
+----------+------+-------------------------------------+
| Protocol | Port | Description |
+----------+------+-------------------------------------+
| tcp | 1525 | oracle |
| udp | 1525 | oracle |
| tcp | 1525 | Prospero Directory Service non-priv |
| udp | 1525 | Prospero Directory Service non-priv |
| tcp | 1525 | Oracle SQL*Net 1 legacy |
|1525 | Oracle SQL*Net 1 legacy
+----------+------+-------------------------------------+
Notice the formatting of the last line in each display. I loaded a text file from notepad. What causes this? How do I fix it?