Unanswered: a quick and simple(?) question about SQL commands
This is a continuation from this thread (another website)
So here is the deal. I am new to mysql but not new to webcode like php/html/flash/ect. I am moving roughly 30,000 users from a vBulliten database (the forum software this forum runs on) into phpprobid software, auction software. Basically signing up 30,000 users to this site for them and then giving them all a $3.00 credit to get the ball rolling. :-)
Okay, so we are dealing with 1 database. The database already has 104 users so we have to add after that.
probid_users = user table moving info into
email = column moving info into
users = user table moving info from
email = column moving info from
I tried using the below script:
FROM user AS u
LEFT JOIN probid_users AS pu ON pu.email = u.email
WHERE pu.email IS NULL
but all that happens is that is takes 341 seconds and then nothing. Nothing gets moved.