Search results for query: *

All Just a case of being stoopid on my part..nothing wrong with MySQL...:) In the destination table..I had created a control field which I used to determine which records had been written across so that I could delete them from the source tables... I then used a script which counted the...

Hi Sleipnir The indices on the source tables are currently set on each of the columns referenced in the predicate of the query. We've tried increasing the env variable for MySQL that covers bulk inserts...its name escapes me at the moment, but doubling it has made precious little difference

Hi sleipnir Thought of that, and have stripped the destination table of all indices (incl PK)- made the query a little faster but it still exhibits the same pattern. The indices on the source tables should not affect an "INSERT...SELECT" query.....or am I wrong?

Hi All My problem is as follows: I am currently running a PHP application that has a MySQL backend (Apache & PHP are on a seperate server to MySQL which is on a dedicated box - P4, 1.6GHz, 512MB RAM, OS: Linux). Part of the application merges data from approximately 900 tables in one DB...

OK..tried it and the code I was asking about in my original post does work...only took me about five minutes to dummy up....laziness never prospers. R

Nope. Being lazy I guess, was just hoping that it would take less time to get an answer than to knock together a test case, but ( insert dramatic_sigh_of_overworked _and_underpaid_person.wav here) I guess it looks like the latter course is becoming necessary. R

I have a script where I have two objects of two different classes, call them Object A and Object B. Object A has a method called Method_A and Object B has a method called Method_B. When I initialise Object B, I pass a reference to Object A and assign it to $Object_A. So far so good.However, now...

This is probably a really newbie question, but I can't search tek-tips at the moment, so I am going to have to post it. I am writing a script where I establish a connection to a mysql db server within the main body of my script. Later I call a homemade function that runs a query via the already...

Hi Dave I am a newbie to PHP (total time 1 day) so I will not be able to give you the PHP code, but in Cold Fusion there is a mathematical operator that I think is fairly common to most languages (and I would imagine is available in PHP), namely modulus. Modulus gives you the remainder and...

Thanks KarveR I was doing that, but it didn't help. My text field was exactly like your example, but I found that if I didn't use the enclosed by parameter, the problem went away (even though the fields are enclosed by ").I will post the issue under a new thread, but I just need to have to...

Hi all This is probably a newbie question, but seeing as that's what I am, please bear with me. I have a file that I need to import (comma-seperated variables) into a MySQL table. There are three fields, two of which are arbitrary, and one in which I am interested. The field I am interested in...