SQL Insert Into Where

Question

INSERT INTO Participant (Password) VALUES ('768YcnaDG') WHERE ParticipantID = 1048

I'm trying to do an insert into SQL command with a where clause. There is an error message that says incorrect syntax near where. How would I go about fixing this?

Gordon Linoff · Accepted Answer · 2020-04-18 00:32:35Z

Presumably, you want UPDATE, not INSERT:

UPDATE Participant SET Password = '768YcnaDG' WHERE ParticipantID = 1048;

INSERT adds an entirely new row into the table. UPDATE modifies the values of one or more columns.

Collectives™ on Stack Overflow

SQL Insert Into Where

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related