>>>>> "sinisa" == sinisa <sinisa@stripped> writes:
sinisa> Robin Bowes writes:
>> Paul DuBois wrote:
>> >
>> > At 7:12 PM +0300 7/26/99, <sinisa@stripped> wrote:
>> > >Robin Bowes writes:
>>
>> [snip]
>>
>> > > >
>> > > > 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.
>>
>> I'm with Paul here. When I do a data import, I want to make sure it is
>> absolutely clean. That is, I need to know exactly what is going on. If
>> there are errors or warnings I want to know why and fix them so I don't
>> get them.
>>
>> Surely, the convention is to dump warnings and errors to stderr? Why
>> can't the mysql client do that? wouldn't take much coding to open a
>> pipe to stderr and dump each warning message, would it?
>>
>> R.
sinisa> Hi!
sinisa> Mysql client can not do that because ALL of it is happening in the
sinisa> server. That is why it is so fast. The only time mysql client is doing
sinisa> anything is when LOCAL attribute is specified for the file.
Hi!
Sinisa is right here; The problem is how to get the warnings to the
client. The ERROR table is the best idea I have seen so far; The
other possibility would be to implement something like what ODBC has:
One could call mysql_error() repeatedly to get all errors. The
problem with this is that this is much harder to do use in a mysql
client (for the end user).
Regards,
Monty
