I've checked through the archives a documentation but cannot find an answer to my problem. I'm attempting to load data from a text file that has a column that is not present in my database table.
Table B C D File A B C D I've been trying to find a way to ignore the first column of the text file by specifiing columns like: (Null,B,C,D) or ('',B,C,D) but mysql doesn't understand these commands. Is there a way to ignore columns with load data? TIA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]