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 <[EMAIL PROTECTED]> 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
