How to Update Field to Add Value to Existing Value

How to update field to add value to existing value?

UPDATE table SET credit = credit + 7 WHERE id = 1

How to update field to push value to existing value in Laravel

Update the answerid with current ids and concat with ,

DB::table('questions')->where('id', $request->questionid)->update(['answerid'=>DB::raw("CONCAT(answerid,',".$answer."')")]);

Oracle: Update a datarow by adding to existing value

All that is needed is to use the concatenation operator, ||. Update syntax does not require that you have a subquery to obtain column2gettingupdated for the value, 12233.

Also, with Oracle VARCHAR2's, you use single quotes and not double quotes. This results in this syntax for this statement:

UPDATE table
   SET column2gettingupdated = 'prefix' || column2gettingupdated
 WHERE SpecificNumber        = 12233;

Here is an example from the example schema SCOTT:

SCOTT@dev> CREATE TABLE DEPT2 as (
  2          SELECT *
  3            FROM DEPT
  4         );

Table created.

SCOTT@dev> commit;

Commit complete.

SCOTT@dev> UPDATE DEPT2
  2     SET DNAME  = 'PRE '|| DNAME
  3   WHERE DEPTNO = 20;

1 row updated.

SCOTT@dev> commit;

Commit complete.

SCOTT@dev> SELECT *
  2    FROM dept
  3   WHERE deptno = 20
  4   UNION
  5  SELECT *
  6    FROM dept2
  7   WHERE deptno = 20
  8  
SCOTT@dev> /

    DEPTNO DNAME          LOC
========== ============== =============
        20 PRE RESEARCH   DALLAS
        20 RESEARCH       DALLAS

How to add a value to existing value using SQL query

update products
set quantity = quantity + 3

Adding value with existing value rails update

You can use several ways to update the value:

with validation:

refund_update.increment('price', 5)

or

refund_update.update_attributes({'price': refund_update.price+5})

without validation:

refund_update.increment!('price',5)

or

refund_update.update_attribute('price', refund_update.price+5)

How to add a value to already existing value in column field and then insert the update value into another table

I would use an insert ... select ... statement to achieve the desired outputs:

INSERT INTO accounts
SELECT members.userid, :amt, members.amount,  :dat FROM members

Notes:

1. I'm using the members.amount in place of members.amount + :amt because the :amt has already been added once to members.amount.

2. Your update statement updates all records within the members table, yet the insert statement would create records for a specific user only. I believe you should restrict the update statement to the specific user only or not restrict the insert to a specific user. I chose the latter approach.

3. If you want to store the balance in a denormalised way, then I would rather use a trigger on the accounts table to update the balance in the members table, than to use 2 statements.

How can I append a string to an existing field in MySQL?

You need to use the CONCAT() function in MySQL for string concatenation:

UPDATE categories SET code = CONCAT(code, '_standard') WHERE id = 1;

Using SQL how can I update field values of one column to match a different column's field value only if the values do NOT equal?

I think this this will work:

UPDATE wc_bidsys_picklist SET vipplays = 'YES' WHERE playoftheday = 'YES' AND game_date='2016-07-20 00:00:00';

Change the date as needed.

---

Related Topics