I have a DB that I've been working on importing data to from text files. The data imports fine, but if its a report that has no data (or just a header) it inserts what seems to be a blank row. usually, I can delete these with a simple SELECT * FROM table WHERE name=''; to be sure, and DELETE FROM table WHERE name='';, neither of which is returning any results.
Also, is there a way to check for this on the import so I won't have the empty rows to deal with in the future.
Thanks so much for any help that anyone can provide.