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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
mysql prepare won't work outside of my loop
Ok, I have decided to bulk load. I will have multiple files that I want to load but I want the data to be average. Is it possible to bulk load one file into mysql than take that data and average it with the next file that is about to be bulk loaded in? How would I be able to do this if so? Thank... -
Error: Column count won't match row???? Help needed
Ok, I have decided to bulk load. I will have multiple files that I want to load but I want the data to be average. Is it possible to bulk load one file into mysql than take that data and average it with the next file that is about to be bulk loaded in? How would I be able to do this if so? Thank... -
mysql prepare won't work outside of my loop
The error is: DBD::mysql::st execute failed: Data truncated for column 'U' at row 1 at line 93, <FILE> line 193348. Couldn't insert record : Data truncated for column 'U' at row 1 at line 93, <FILE> line 193348. This is the updated version when I move the prepare statement and the... -
mysql prepare won't work outside of my loop
Line 93 is the "Execute statement" <CODE> $sth->execute ($lat, $longi, $x, $y, $resultant, $variance_speed, $angle, $variance_angle) || die "Couldn't insert record : $DBI::errstr"; </CODE> The error is the "Data truncated error", but only when I move the prepare outside the loop and place... -
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!!!
Sorry this is the working script. That one does not work. #!/usr/local/bin/perl #opening narr files use warnings; use strict; use Math::Trig; use DBI; my ($id, $variance_speed, $variance_angle, $stnd_dev, @x, @y, $date, $hour, $dbh, $sth, $x, $y, $lat, $longi, $theta, $rho, $R, $pi, $rads... -
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...
