Suppose I have a table 'tbl' with 4-field schema: f1,f2,f3,f4. I have bunch of data (in csv form whose list order of fields are same as table schema's [cause I design it] but leave the field-f3 value as ',,' in csv) needed to correct from my users but only leave f3 unchanged. I image there's such an update statement as:
UPDATE tbl VALUES ('new-f1-val','new-f2-val', IGNORE, 'new-f3-val')
where when db engine sees this statement, it will recognize IGNORE as a system predefined reserved word/constant that tells db engine to ignore (i.e. NOT TO) updating this particular field. I'm not telling fairy tale cause I constantly face these needs from my users.
Is there such statement in MySQL, whether current or future, or any equivalent statements/procedures to achieve same result?
==================================
Many people don't understand why I image this kind of statement, so I'll tell my practical motivation here:
==================================
EDIT: I add description of file format of data that users gave me to refine my question.
==================================
You should always explicitly add the columns you want to update in a table, it's good practice, your need for shortening the query notwithstanding.
That being said, try inserting "null" and checking if it works. No guarantee here, haven't tried so myself.