Upload on matching primary key

roneill

Can you help?

I would to update data on my MYSQL database using a text file upload.

In access it is possible to run an update query on a database that will match rows in one table with rows in another table using each tables primary key. Is it possible to do this in MYSQL?

Let me give you an example:

I have a table with 2 columns - of data. 'Primary Key' and 'score'.

I would like to update the score column using a text file that contains the 'primary key' and a new 'score'.

Obviously I need to match the primary key in the MYSQL DB with the primary key on the text file other wise the wrong score will go to the wrong primary key.

I understand that this may be a 1,2,3 stage procress, but is it possible????

Thanks in advance

Ryan

sledgeweb

It is possible, you will just need to add some SQL instructions to your text file. Or you could write a PHP page that allows you to upload a text file in a certain format, then it parses that file and adds the SQL syntax needed and then processes the file to update the data in the database. I've done something similar to that for importing large text files into a database.

-Sledge

roneill

Thank you sledgeweb,

But what sort of SQL??

Creating a php page that allows files to be uploaded in a certain format is exactly what I wish to do!!!

But what SQL code would do this on matching keys??

An example would be much appreciated

Ryan

kevinsequeira

STEP 1: create a text file in a specific format
eg. primarykey,score
so that the file will contain
1,50
2,60
3,70
STEP 2: create a PHP page to upload the text file to the server or ftp the file
STEP 3: read the text file line by line extracting values of primary key and corresponding score
STEP 4: using the extracted values, update the table

is this enough or do you need help with the implementation ??

reg
kevin