Webmaster Forum
Go Back   Webmaster Forums UK SEO SEM Webmaster Community Forum > Web Design and Website Development > Programming > MySQL Forums
Register FAQ Members List Downloads Calendar Search Today's Posts Mark Forums Read Webmaster Resources Webmaster Blogs

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-05-2008, 01:05 PM
Junior Member
 
Join Date: May 2008
Posts: 2
iTrader: 0 / 0%
prober is on a distinguished road
Default table is not loading correctly

I use the tutorialīs instructions and try to load data into the client table with this command...
load data local infile 'c:/mysql/client.txt' into table client;

the table is populated but itīs missing some of the first letters of the first column. whatīs wrong?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Stumble this Post!
Reply With Quote
  #2 (permalink)  
Old 05-05-2008, 04:55 PM
Junior Member
 
Join Date: May 2008
Posts: 2
iTrader: 0 / 0%
prober is on a distinguished road
Default 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...:-(
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Stumble this Post!
Reply With Quote
Reply


Useful Resources & Sites
• Search Engine Marketing Company
• UK Web Hosting
• Build One Way Links
 
 
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 05:20 PM.

UK Webmaster World Forums - Internet marketing, web development, domain names, SEO contest and discussuons.
Subscribe to our feeds   Subscribe to our feeds

Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0