List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 26 1999 5:04pm
Subject:Re: How to see warnings...
View as plain text  
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.
>
>
>
>Hi!
>
>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
Thread
How to see warnings...Robin Bowes26 Jul
  • How to see warnings...sinisa26 Jul
    • Re: How to see warnings...Martin Ramsch26 Jul
      • Re: How to see warnings...()27 Jul
        • Re: How to see warnings...Thimble Smith27 Jul
          • Re: How to see warnings...sinisa27 Jul
            • Re: How to see warnings...Thimble Smith27 Jul
              • Logging...Chris J. DiBona27 Jul
        • Re: How to see warnings...Martin Ramsch27 Jul
    • Re: How to see warnings...Paul DuBois26 Jul
  • Re: How to see warnings...Robin Bowes27 Jul
    • Re: How to see warnings...sinisa27 Jul
      • Re: How to see warnings...Michael Widenius2 Aug
Re: How to see warnings...David Kaufman26 Jul