List:General Discussion« Previous MessageNext Message »
From:Ferindo Middleton Date:June 23 2006 8:33pm
Subject:Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
View as plain text  
I guess my general reason for posting this was to ask: "Are there any known
issues with the LOAD DATA INFILE comand in MySQL?" However, I stripped all
the data in the file (test.tab) down to one record which still wouldn't
load. Here is the command:

mysql> LOAD DATA INFILE 'C:/Program Files/Apache Software Foundation/Tomcat
5.5/
webapps/utrad/docs/rebuild_scratch_area/test.tab' INTO TABLE reggie;

The fields inside the file are tab-delimited and look like this:
16411 5 Rupert Settles Settles Settles 1 esunindyo \N 207 \N 12 \N
2005-01-03 2005-01-07 1 1 1 0 \N Deobligation 1 2 \N fmiddleton 0 0 \N
\N 11:00:00 \N \N \N 0 0 4 0 0 \N \N \N 1

The structure of the TABLE reggie is this:

CREATE TABLE `reggie ` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `title_salutation_id` bigint(20) unsigned NOT NULL,
  `firstname` varchar(128) NOT NULL,
  `middlename` varchar(128) NOT NULL default '',
  `lastname` varchar(128) NOT NULL default '',
  `suffix` varchar(128) NOT NULL default '',
  `paper_received` tinyint(1) NOT NULL default '1',
  `addr` text,
  `cc_email_list` text,
  `fortran_id` bigint(20) default NULL,
  `office` text,
  `class_id` bigint(20) unsigned NOT NULL,
  `schedule_id` bigint(20) default NULL,
  `start_date` date NOT NULL default '0000-00-00',
  `end_date` date NOT NULL default '0000-00-00',
  `enrolled` tinyint(1) default NULL,
  `attended` tinyint(1) default NULL,
  `completed` tinyint(1) default NULL,
  `cancelled` tinyint(1) default '0',
  `cancelled_comments` text,
  `comments` text,
  `email_confirmation_sent` tinyint(1) NOT NULL,
  `employment_status_id` bigint(20) unsigned NOT NULL default '0',
  `last_updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
  `last_user_updated` text,
  `waitlisted` tinyint(1) default '0',
  `overflow_registrant` tinyint(1) default '0',
  `attach_hotel_listing_directions` tinyint(1) default NULL,
  `instructor_legacy` text,
  `time_legacy` time default NULL,
  `ssn_legacy` text,
  `position_grade_title` text,
  `office_phone_legacy` text,
  `contractor_legacy` tinyint(1) default NULL,
  `no_show` tinyint(1) default NULL,
  `funding_id` bigint(20) unsigned NOT NULL default '0',
  `incomplete` tinyint(1) default NULL,
  `prerequisites_completed` tinyint(1) default NULL,
  `score` smallint(5) unsigned default NULL,
  `per_diem_cost` decimal(10,0) default NULL,
  `travel_cost` decimal(10,0) default NULL,
  `first_migration` tinyint(1) unsigned default NULL,
  PRIMARY KEY
(`firstname`,`middlename`,`lastname`,`suffix`,`class_id`,`start_date`,`end_date`),
  UNIQUE KEY `id` (`id`),
  KEY `fk_registration_class_id_must_always_match_a_classes_id`
(`class_id`),
  KEY `fk_registration_title_id_must_always_match_title_salutations_id`
(`title_salutation_id`),
  KEY `fk_registration_bureau_id_must_always_match_a_bureaus_id`
(`bureau_id`),
  KEY `fk_funding_id_check_for_registration_and_attendance` (`funding_id`),
  KEY `fk_employment_status_id_check_for_registration_and_attendance`
(`employment_status_id`),
  CONSTRAINT `fk_employment_status_id_check_for_registration_and_attendance`
FOREIGN KEY (`employment_status_id`) REFERENCES `employment_statuses`
(`id`),
  CONSTRAINT `fk_funding_id_check_for_registration_and_attendance` FOREIGN
KEY (`funding_id`) REFERENCES `funding_types` (`id`),
  CONSTRAINT `fk_registration_bureau_id_must_always_match_a_bureaus_id`
FOREIGN KEY (`bureau_id`) REFERENCES `bureaus` (`id`),
  CONSTRAINT `fk_registration_class_id_must_always_match_a_classes_id`
FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`),
  CONSTRAINT
`fk_registration_title_id_must_always_match_title_salutations_id` FOREIGN
KEY (`title_salutation_id`) REFERENCES `title_salutations` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Do you know why this this one data record won't load?... why MySQL says:
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed

Ferindo

On 6/23/06, Gerald L. Clark <gerald_clark@stripped> wrote:
>
> Ferindo Middleton wrote:
> > I'm trying to load data into a table from a file but I get an error
> > message:
> >
> > ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
> >
> > This error message isn't very specific as to what is going wrong and I
> have
> > no idea what it is about the data file that is wrong. Of course, I know
> > that
> > there is in fact data in the file and that it is proper data types
> matching
> > the table structure so I don't know why this error message is occuring
> or
> > what it is about the file that's stopping it from being loaded.
> >
> Since you did not show us the data, nor the command you used to load the
> data, we can't tell you what is wrong.
>
> --
> Gerald L. Clark
> Supplier Systems Corporation
>



-- 
Ferindo Middleton
Technical Lead - Research and AUI Infrastructure Development
Sleekcollar Software

Thread
error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processedFerindo Middleton23 Jun
  • Re: error loading data from file > ERROR 1329 (02000): No data -zero rows fetched, selected, or processedGerald L. Clark23 Jun
    • Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processedFerindo Middleton23 Jun
      • Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processedFerindo Middleton26 Jun
        • Re: error loading data from file > ERROR 1329 (02000): No data -zero rows fetched, selected, or processedDan Buettner26 Jun
          • Re: error loading data from file > ERROR 1329 (02000): No data - zero rows fetched, selected, or processedFerindo Middleton27 Jun