Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
String variable won't work outside of loop.
I was wondering why, in the following script, it will not run when I place the prepare outside of the loop and put in $uwind[$i] and $vwind[$i] for the place holders in the values part? This script works: open(FILE, $filename) or die "$!"; @uwind = <FILE>... -
How put 900,000,000 rows of data into mysql fast!!!
I need to get data from text files and put them into a mysql table. The problem is there are about 900,000,000 million rows of data and I want to do it as fast as possible. Here is a script that works but it just takes a very long time to load the data. Is it possible to do it any faster? Thank... -
Error: Column count won't match row???? Help needed
I am wanting to upload data into a mysql table as fast as possible and so I made a string so it will load multiple rows at once. However, when I run it I get an error saying: DBD::mysql::st execute failed: Column count doesn't match value count at row 1 Now, I know that I may have not enough or... -
mysql prepare won't work outside of my loop
Hi, I need help with the script below: I am uploading MILLIONS of data into a mysql table and I want to make it run faster by moving the prepare statement out of the loop. However, every time I do I recieve an error that says I have an error in my mysql syntax. I don't get it because it works...
