Tutorial :Set a column value at a specified row [closed]



Question:

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


Solution:1

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  


Solution:2

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

More info about INSERT: http://www.w3schools.com/sql/sql_insert.asp

More info about UPDATE: http://www.w3schools.com/sql/sql_update.asp


Solution:3

Try taking a look at UPDATE rather than INSERT.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »