Have Geek Brain

Set the column value at the specified row

How can I set the value of a column at a specified row?

0


a source to share


3 answers


Not sure if you are trying to insert a new row or update a row that meets certain criteria. If the second is true, you need:



UPDATE table_name 
SET column1 = value, column2 = value2 
WHERE some_column = some_value
+2


a source


To read more about SQL: http://www.w3schools.com/sql/default.asp

More information on INSERT: http://www.w3schools.com/sql/sql_insert.asp



More information on UPDATE: http://www.w3schools.com/sql/sql_update.asp

+5


a source


Try looking at UPDATE, not INSERT.

0


a source






More articles:


All Articles