mora info..with this problem
ok these are the records in the text file I created to load into the mysql table..(using notepad, writing records immediatly at the begining of notepad editor and separating each element with a tab space )
Fluffy 1995-05-15 litter 4 kittens, 3 female, 1 male
Buffy 1993-06-23 litter 5 puppies, 2 female, 3 male
Buffy 1994-06-19 litter 3 puppies, 3 female
Chirpy 1999-03-21 vet needed beak straightened
Slim 1997-08-03 vet broken rib
Bowser 1991-10-12 kennel /N
Fang 1991-10-12 kennel /N
Fang 1998-08-28 birthday Gave him a new chew toy
Claws 1998-03-17 birthday Gave him a new flea collar
Whistler 1998-12-09 birthday First birthday
I load them into the table and when I try to see them with select * from
it shows the table incomplete missing letters from the elements of the first column.....gives me no error whatsoever... i'm puzzled.
as far as i have worked with this database only once has it worked properly, but since that time always is the same problem, using load data local infile gives me an incomplete table...:-(
|