MySQL - 插入如果存在更新

Question

I have unknown keys and values to import to database from CSV.
My code is

while($data = fgetcsv($handle,1000,",",'"'))
{
$data=array_map('addslashes',$data); // apply addslashes() to all values
$data=array_combine($csv_fields,$data); // csv fields assoc (key=>value)
$data=array_intersect_key($data,$tbl_fields); // discard redundant
$tbl_fields_str=implode("`,`",array_keys($data));
$tbl_vals_str=implode("','",array_values($data));
$q="INSERT INTO `cmid` (`cmid`,`$tbl_fields_str`) VALUES ('$cmidtrenutni','$tbl_vals_str') ON DUPLICATE KEY UPDATE (`$tbl_fields_str`) VALUES ('$tbl_vals_str')";
$conn->query($q); 
}

I need to insert and if exist, update. I try this code above but doesnt work.
I find something like http://dev.mysql.com/doc/refman/5.5/en/insert-on-duplicate.html
But this doesnt help in my way cause my table doesnt have defined fields. Keys and values are different on every input.
Any solution how to do this?

Answer 1

This is your query:

INSERT INTO `cmid` (`cmid`, `$tbl_fields_str`)
    VALUES ('$cmidtrenutni', '$tbl_vals_str')
    ON DUPLICATE KEY UPDATE (`$tbl_fields_str`) VALUES ('$tbl_vals_str');

The problem is the UPDATE part. You need to split the values so it looks like:

INSERT INTO `cmid` (`cmid`, `$tbl_fields_str`)
    VALUES ('$cmidtrenutni', '$tbl_vals_str')
    ON DUPLICATE KEY UPDATE
         col1 = newcol1val,
         col2 = newcol2val,
         . . .

The short-hand that you are using is not valid syntax.