I have a table in mysql called form_instances with the following three fields:
id
student_id
form_id
I want to import records from a tab-delimited file with only two fields: student_id form_id
I'm using the command: mysqlimport -u root -p student_db /path/to/form_instances.tab
This promptly stuffs the student_id into the id slot and the form_id into the student_id slot. I think you know what my question is... How do I import a tab-delimited file and align the incoming data with the appropriate fields?
Many Thanks, Ari D.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]