Search
Search

Mysql, copy a cell value from another row in the same table

debugcn Published at Dev
15
user2301515

How to copy a cell value from another row in the same table?

UPDATE mytable SET myvalue=(SELECT myvalue FROM mytable WHERE id=2) WHERE id=11

It gives an error message:

Table 'mytable' is specified twice, both as a target for 'UPDATE' and as a separate source for data

Thank you

Tomm 
UPDATE mytable SET id=11, mycol=a.mycol FROM (SELECT mycol FROM mytable WHERE id=2) a

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Get value from mysql table in same cell as another value PHP

From Dev

copy one row from a table to another and insert value of one column in same query

From Dev

copy one row from a table to another and insert value of one column in same query

From Dev

To copy a row and insert in same table with a one different value for a field in MySQL

From Dev

Value of a cell in the same row as the max value in another

From Dev

Retrieving variables from a mySQL table to be used in another row in the same table?

From Dev

Update MySQL datetime column with subtracted value from another row in same table

From Dev

MySQL: Copy Multiple Values from random row of another table

From Dev

Excel function to copy cell value above IF current cell empty and another cell in same row is anything but empty. Otherwise, do nothing

From Dev

MySQL select from a table and check in another table if the same value exists

From Dev

Get value of a table cell in another row

From Dev

Excel Macro to copy select cells from a row from one sheet to another based upon a cell value

From Dev

Copy cell from on sheet to another, if other cell in row matches values

From Dev

Row value from another table

From Dev

Python - How to iterate through a dataframe and replace a value in one cell with a value from another in the same row

From Dev

Copy mysql row value from row below?

From Dev

Copy a row from one table to another

From Dev

Jquery - copy a row from one table to another

From Dev

Copy the cell value to another cell if

From Dev

Get a cell value from a row based on another cell value

From Dev

Fetch a cell data by clicking another cell data from same row

From Java

Copy cell that equals cell value from another worksheet

From Java

Copy Row To Another Sheet Based On Cell Value In Google Sheet

From Dev

excel copy row to another sheet based on cell value

From Dev

Copy Specific data (Not the entire row!) to another sheet based on cell value

From Dev

pass value of cell from table row to variable

From Dev

SQL: Copy value from column to another row in same column if condition is met

From Dev

Mysql same row copy-same table 120 times

From Dev

how to copy a cell from one worksheet to another, to the correct row

Related Related

  1. 1

    Get value from mysql table in same cell as another value PHP

  2. 2

    copy one row from a table to another and insert value of one column in same query

  3. 3

    copy one row from a table to another and insert value of one column in same query

  4. 4

    To copy a row and insert in same table with a one different value for a field in MySQL

  5. 5

    Value of a cell in the same row as the max value in another

  6. 6

    Retrieving variables from a mySQL table to be used in another row in the same table?

  7. 7

    Update MySQL datetime column with subtracted value from another row in same table

  8. 8

    MySQL: Copy Multiple Values from random row of another table

  9. 9

    Excel function to copy cell value above IF current cell empty and another cell in same row is anything but empty. Otherwise, do nothing

  10. 10

    MySQL select from a table and check in another table if the same value exists

  11. 11

    Get value of a table cell in another row

  12. 12

    Excel Macro to copy select cells from a row from one sheet to another based upon a cell value

  13. 13

    Copy cell from on sheet to another, if other cell in row matches values

  14. 14

    Row value from another table

  15. 15

    Python - How to iterate through a dataframe and replace a value in one cell with a value from another in the same row

  16. 16

    Copy mysql row value from row below?

  17. 17

    Copy a row from one table to another

  18. 18

    Jquery - copy a row from one table to another

  19. 19

    Copy the cell value to another cell if

  20. 20

    Get a cell value from a row based on another cell value

  21. 21

    Fetch a cell data by clicking another cell data from same row

  22. 22

    Copy cell that equals cell value from another worksheet

  23. 23

    Copy Row To Another Sheet Based On Cell Value In Google Sheet

  24. 24

    excel copy row to another sheet based on cell value

  25. 25

    Copy Specific data (Not the entire row!) to another sheet based on cell value

  26. 26

    pass value of cell from table row to variable

  27. 27

    SQL: Copy value from column to another row in same column if condition is met

  28. 28

    Mysql same row copy-same table 120 times

  29. 29

    how to copy a cell from one worksheet to another, to the correct row

HotTag

Archive