Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

data load formatting problem.

Status
Not open for further replies.

macubergeek

IS-IT--Management
Dec 29, 2004
41
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top