| load data problem [message #70334] |
Tue, 28 May 2002 07:28  |
Delphin Muteba
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
Dear,
I have fields with varchar type on my database and i use the load data command for populate my table from a text file where fields are terminated by ' '.After loading, the select command gives "0 row" for varchar type fields.
I don't know what to do because i have a lot of data in my file and must use the load data command.
|
|
|
|
| Re: load data problem [message #70336 is a reply to message #70334] |
Tue, 28 May 2002 18:36  |
N. Rammohan
Messages: 5
Registered: May 2002
|
Junior Member |
|
|
suppose if you have the fields like this
field 1 field 2
'abcdefghijk''lmnopqrst'
load data
infile filename
append into table tablename
(field1 position(2:13),
field2 position(16:25)
then do usual loader procedure
revert if it works
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
