At 7:12 PM +0300 7/26/99, <sinisa@stripped> wrote:
>Robin Bowes writes:
> > Hi,
> > I'm doing a pretty straightforward insert based on a select statement.
> > The sql is as follows:
> > insert into Case
> > select
> > Number,
> > Name,
> > Region,
> > if(subhear=0, 'Y','N'),
> > Place,
> > FrstHear,
> > Year,
> > Represent,
> > if(allmaleit=1, 'Y', 'N'),
> > ChairIT,
> > Injury,
> > Award
> > from
> > smart;
> > When I run it, I get the following results:
> > Query OK, 6313 rows affected
> > Records: 6468 Duplicates: 155 Warnings: 5
> > The duplicates aren't a problem - I can weed those out manually.
> > What I would like to know is how to see what the warnings are.
> > Any suggestions?
> > Thanks,
> > R.
>Warnings are usually connected with incompatibilities between field
>types of the different tables.
>They are not too serious, that is way they are only warnings.
I don't know about that. Suppose you're importing data with date values,
and the date format is different than what MySQL expects. Okay, so
the file gets read in and you have a bunch of warnings. In fact, what
I may have is a date column full of "0000-00-00" values.
Not serious? I guess I'd say warnings are something to pay attention to.
Unfortunately, it's difficult to determine the cause of the warnings.
Paul DuBois, paul@stripped