Update table field with information from another column

Question

How to do an update that recovers data from one column and plays in another column? For example

Sales

IdVenda | dataVenda  | dataPgto
1       | 2017-08-21 | 
2       | 2017-08-21 |

Want to update the dataPgto with the dataVenda information? PS: this sale would be made with credit card.

Answer 1

Hello,

Just do the update by referencing one column to another, example:

UPDATE vendas SET dataPgto = dataVenda;

Follow a fiddle with practical example:

https://www.db-fiddle.com/f/5ozLMhyMZXTtQHWD3vzRTK/0

Answer 2

Being the same table you won’t need to Join or something like that; just know the update condition, in case the id of the item that will be updated (idVendaEfetuada):

UPDATE tabela_vendas SET dataPgto = dataVenda WHERE IdVenda = idVendaEfetuada