Query Update row with data from another row in the same table

Question

I have table like this... with 3000+ records..

╔═════╦════════╦═════════════╗
║ id  ║  text  ║  parent_id  ║
╠═════╬════════╬═════════════╣
║   1 ║  asas  ║           0 ║
║   2 ║  fgh   ║           0 ║
║   3 ║  jkl   ║           0 ║
║   4 ║  kkk   ║           0 ║
║   5 ║  test  ║           0 ║
║   6 ║  asd   ║           0 ║
║   7 ║  dsa   ║           0 ║
╚═════╩════════╩═════════════╝

how to change the parent_id value to same like id? to like this...

╔═════╦════════╦═════════════╗
║ id  ║  text  ║  parent_id  ║
╠═════╬════════╬═════════════╣
║   1 ║  asas  ║           1 ║
║   2 ║  fgh   ║           2 ║
║   3 ║  jkl   ║           3 ║
║   4 ║  kkk   ║           4 ║
║   5 ║  test  ║           5 ║
║   6 ║  asd   ║           6 ║
║   7 ║  dsa   ║           7 ║
╚═════╩════════╩═════════════╝

and more..... until 3000+records..

UPDATE table SET parent_id = id?

piotrgajow
– piotrgajow

2016-03-18 10:40:42 +00:00
Commented Mar 18, 2016 at 10:40 — piotrgajow
– piotrgajow, Commented Mar 18, 2016 at 10:40

Klaus Byskov Pedersen · Accepted Answer · 2016-03-18 10:40:52Z

2

It's as simple as:

update yourtable set parent_id = id

answered Mar 18, 2016 at 10:40

Klaus Byskov Pedersen

122k31 gold badges192 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query Update row with data from another row in the same table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related