INSERT INTO db (id,price,dost,name,field1,field2,field3) VALUES ('65','659', '1','qwery','dfsdd','burgers','zxcdf')
Due to the fact that the table has a PRIMARY KEY, records with NOT unique field ID in the database does not get Duplicate entry Error
But can I update some fields if the DB saw the double?
There is a request database, SQL sees that the request contains double - ie ID is already in the database, and UPDATES the row for example on the columns price and fild3 for duplicate rows (ID).
Thank you very much for your help in solving the problem.