12 messages in com.mysql.lists.win32Text import/export problems| From | Sent On | Attachments |
|---|---|---|
| David H | 27 Nov 2003 02:02 | |
| Petr Vileta | 27 Nov 2003 07:21 | |
| David H | 27 Nov 2003 18:12 | |
| David H | 27 Nov 2003 18:45 | |
| David H | 27 Nov 2003 18:56 | |
| David H | 27 Nov 2003 19:36 | |
| David H | 27 Nov 2003 20:18 | |
| Vani | 27 Nov 2003 21:11 | |
| David H | 30 Nov 2003 18:28 | |
| David H | 01 Dec 2003 05:15 | |
| Groberts1 | 01 Dec 2003 06:52 | |
| David H. | 06 Dec 2003 15:28 |
| Subject: | Text import/export problems |
|---|---|
| From: | Groberts1 (grob...@austin.rr.com) |
| Date: | 12/01/2003 06:52:51 AM |
| List: | com.mysql.lists.win32 |
Hi,
I am importing text data from many files using the LOAD DATA LOCAL INFILE command and am getting almost as many warnings as rows imported.
1. I have read the documentation and seen the comment somewhere on www.mysql.com that SHOW WARNINGS is not implemented yet (at least not as of the version I downloaded two weeks ago). Does anyone know when SHOW WARNINGS will be implemented? Is there any way to make it work without upgrading to a new version? I just got past the Error 1067 error again after an uninstall/reinstall...
2. The SELECT ... INTO OUTFILE command exports at most 1,000 rows. How do I make it export the entire table?
3. I suspect the warnings are telling me about cases where NULL has been assigned where there is no data in a column. However, there are many cases where this does not happen with my data even when the "cell" is empty. Why does the NULL substitution sometimes happen and sometimes not? To deal with this variability my queries are going to be a lot more complicated, since I will have to add "or IS NULL <here and there>" to every comparison (not just "=").
TIA,
Gregg Roberts