Batch Update of records

2006-08-26 Thread Neil Tompkins
Hi I've am updating a database with about 20,000 records. What is the best way to perform these updates. Can I use batch updating ? Thanks Neil _ Be one of the first to try Windows Live Mail.

Re: Batch Update of records

2006-08-26 Thread Rocco
Hallo Neil, take a look at the utility mysqlimport which will exactly fit your needs importing those records into a database table. The basic syntax is: mysqlimport options database_name table_name.txt Tablename.txt would be your datafile with the records. The filename must match the name