I am using MySQL version 3.23.11-alpha on Win98. I have created a
database with a table borrower whose description is as follow:
mysql> describe borrower;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| customer_name | varchar(20) | YES | | NULL | |
| loan_number | varchar(5) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
I use the following to load the data stored in borrower.txt into
the table borrower :
mysql> load data local infile "c:\\data\\borrower.txt" into table
borrower;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 1
Case 1:
The file borrower.txt looks like the following :
Adams L-16
Curry L-93
Hayes L-15
Jackson L-14
Jones L-17
Smith L- 11
Smith L-23
Williams L-17
When I run a select query i get the following output :
mysql> select * from borrower;
+---------------+-------------+
| customer_name | loan_number |
+---------------+-------------+
| Adams | L-16 |
| Curry | L-93 |
| | L-15
|n | L-14
| | L-17
| Smith | L- 11 |
| | L-23
| Williams | L-17 |
+---------------+-------------+
8 rows in set (0.06 sec)
Case 2:
When the contents of borrower.txt is changed to no spaces in
between name and loan_number :
AdamsL-16
CurryL-93
HayesL-15
JacksonL-14
JonesL-17
SmithL-11
SmithL-23
WilliamsL-17
The data stored in the table is:
mysql> select * from borrower;
+---------------+-------------+
| customer_name | loan_number |
+---------------+-------------+
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
+---------------+-------------+
8 rows in set (0.00 sec)
Why was the data not correctly loaded into the table? Please Help
me.
Regards,
Vaibhav Jha.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
