in reply to perl mysql - INSERT INTO, 157 columns

Other than making sure your VALUES are in the correct order so you can skip the field list, no. Otherwise, you want to find a bulk loader. It wouldn't surprise me if such a thing existed, mysql being popular, but I am not personally familiar with the database. We made good use of SQL*Loader when I was working with Oracle several years and jobs ago.

1 Peter 4:10
  • Comment on Re: perl mysql - INSERT INTO, 157 columns