Is there a way that I can duplicate the required row, insert the the correct info i.e. so can u suggest v gud book which is free in downloading and tel best site where v can find various examples on queries. You will use the WHERE clause of the UPDATE statement to restrict the update to a single row. The basic syntax is: INSERT, table name, column list, VALUES, and then a list of the values to be inserted.The two hyphens in front of a line indicate that the line is a comment and the text will be ignored by the compiler.If it does, then only one of the join rows will be used to update the target row, but which one will be used is not readily predictable.Because of this indeterminacy, referencing other tables only within sub-selects is safer, though often harder to read and slower than using a join.  Set the value of column C1 in table T to 1, only in those rows where the value of column C2 is "a".The table should have the following fields:surname,firstname,you please help me with the Mysql statement to do so.