im trying to insert data into a specific row in the database, but mysql says 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'
Link to documents .
Instead, you can UPDATE ,
UPDATE user set rep='5', course='computer science' WHERE user='2'
INSERT WHERE.
INSERT WHERE, INSERT, - , ?
INSERT
WHERE
, WHERE INSERT....
: UPDATE table-name SET column=val WHERE some cont
UPDATE table-name SET column=val WHERE some cont
Command if you need to update an existing row ....
Source: https://habr.com/ru/post/1769833/More articles:Routing / in Rails - ruby-on-railsSELECT with array () - phpJavaScript - onmouseover change previous css height element - javascriptDrawing in the context of a bitmap - cocoa-touchIn django-haystack, how can I use subclasses of models? - djangoТаблицы Wiki для Multi-sort Media - sortingFiltered index versus normal non-clustered index - sql-serverSaving Variables (Android) - variablesКакой хороший способ отобразить загружаемое изображение до тех пор, пока не будет завершен запрос ajax? - javascriptCan I use two separate SQLite databases? - databaseAll Articles