im trying to insert data into a particular row in the database, but i mysql is saying this is an error:
INSERT INTO user (rep, course) VALUES('5', 'computer science') WHERE user='2'
im trying to insert data into a particular row in the database, but i mysql is saying this is an error:
INSERT INTO user (rep, course) VALUES('5', 'computer science') WHERE user='2'
UPDATE user
SET rep = '5', course = 'computer science'
WHERE user = '2'
You might want to UPDATE instead,
UPDATE user set rep='5', course='computer science' WHERE user='2'