SQL Replace Into question
- by Matt
With Replace Into, if I have two fields. FirstName LastName. The table has John Smith in it, if I was to run REPLACE INTO tblNames (FirstName, LastName) VALUES (John, Jones)
Would that replace Smith with Jones, or create a new name?
What determines if its an Update or and Insert?