How do I view warnings on a data import?

This topic is empty.

Viewing 10 reply threads

Author

Posts
- April 6, 2004 at 7:31 pm #8388
  
  ekraft84
  Member
  
  Hey All,
  
  When I'm importing data from a .CSV file, I'll get a status message saying if the import was successful or not, and then a listing showing how many records were imported, how many weren't, and how many warnings existed. How can I see what these warnings are?
  
  Thanks.
- April 7, 2004 at 2:01 am #15642
  
  Ritesh
  Member
  
  Hello,
  
  SQLyog uses MySQL's standard LOAD DATA LOCAL…. SQL to import data from a CSV file. The warning message is the one returned by MySQL on execution of the statement. For more information about what these messages mean check out http://www.mysql.com/doc/en/LOAD_DATA.html
- April 19, 2004 at 8:26 pm #15643
  
  ekraft84
  Member
  
  Right, but how do I actually view the warnings within SQLyog? I see that there are X number of warnings, but I don't know where see what they are exactly.
  
  Thanks.
- April 28, 2004 at 4:06 pm #15644
  
  ekraft84
  Member
  
  Anyone else know how to view warnings?
- April 30, 2004 at 12:37 pm #15645
  
  Shadow
  Member
  
  From MySQL 4.1.1 on use SHOW WARNINGS statement to retrieve the errors (see MySql manual for details abot SHOW WARNINGS). Before this version, the warning counter is used for indicating that something was not OK, but the warnings are not stored. Hint: warnings happen under same circumstances as if INSERT statement had been issued.
- April 30, 2004 at 1:24 pm #15646
  
  ekraft84
  Member
  
  Cool – thanks for the info.
  
  So I import a set number of records in SQLyog and then get the message box popping saying, “x number of warnings”. Do I think enter “show warnings” to see them? Or do I need to include “show warnings” within the query itself?
  
  Thanks.
- May 3, 2004 at 10:10 pm #15647
  
  Shadow
  Member
  
  Just issue a “SHOW WARNINGS;” command (press F5), this will do the job. I think SQLyog has a built-in menu for this (I don't have access to SQLyog right now).
- May 4, 2004 at 11:12 am #15648
  
  ekraft84
  Member
  
  I think your crazy. 🙂 I cannot get warnings to show for the life of me.
- May 8, 2004 at 4:48 pm #15649
  
  sadab00
  Member
  
  The important part of one of the previous posts was:
  
  MySQL version 4.1 allows you to view warnings.
  
  Prior to that version, the SHOW WARNINGS; statement does not work because the warnings were not actually stored in the previous versions. In 4.1.1 it does work for me.
- May 10, 2004 at 2:53 pm #15650
  
  ekraft84
  Member
  
  Yes, I see this.
  
  However, I do an import from a text file, and I get an “Import Successful” message box giving me the number of records successfully imported, the number deleted, and then the number of warnings.
  
  After I click “OK”, then what? The query has been run. How do I show warnings now?
- May 10, 2004 at 3:22 pm #15651
  
  ekraft84
  Member
  
  Alright, I now see that you can type “show warnings” to display any warnings that were generated on the previously run query.
  
  Unfortunately, the client does not have mySQL 4.1. 🙁
Author

Posts