LOAD DATA skips records of text file

2003-10-26 Thread Heinrich Stoellinger
I have a small dBase4 Database that contains 260 records. Exporting it to a text file and then using LOAD DATA into table... I see that of the 260 records only 204 get loaded. I cannot make out what is specific about the records skipped. I do get warnings but (since I am using only 4.1.0 alpha!

EXISTS Clause

2003-11-02 Thread Heinrich Stoellinger
Does MySQL support the "EXISTS" / "NOT EXISTS" clause in table query statements? What I want to do is to find tuples which do NOT have corresponding tuples in another table. For example - tell me who in my person table does not have an email address. -- MySQL General Mailing List For list arc