Results 1 to 1 of 1
|
Enjoy an ad free experience by logging in. Not a member yet? Register.
|
|
-
02-01-2007 #1
- Join Date
- Oct 2004
- Posts
- 18
MySQL - imported delimited file, displays odd
i have just imported a tab delimited file into a MySQL table, here is the contents of the file i imported:
first.last,182885
john.citizen,837465
my.name,976548
your.name,8216431
debian.linux,313337
hello.world,847563
the command i used to import it:
Code:load data infile 'd:/test' into table passwords fields terminated by ',';
when i query the database, everything works fine and a username is picked up in full, and i get results, however, things arent displaying properly in the command line client.
for instance, a show all gives me this:
Code:mysql> select * from passwords; +--------------+----------+ | userName | password | +--------------+----------+ | rst.last | 182885 | hn.citizen | 837465 | .name | 976548 | our.name | 8216431 | bian.linux | 313337 | hello.world | 847563 | +--------------+----------+ 6 rows in set (0.00 sec)
any ideas?