SQL for beginners: UPDATE statement

preview_player
Показать описание
The data stored in database tables rarely stay the same. Time and time again, the old one needs to be replaced the latest version or a new one. As a result, we need to update the database regularly. For example, if you need to change employees’ data, like their job title, telephone number or email, you can use the UPDATE statement for this.
--

--
Contact us:

--
Subscribe to our channel to get more interesting videos about DBeaver and the database world!
Рекомендации по теме
Комментарии
Автор

Hello. There is a column with date values. I only want to change the year. and specify the data type in the script date. Can u halp me?

danko
Автор

what does it do and what is its purpose

iegely
Автор

Hi, when are the next videos coming (other basic statements, or eventually aggregations, joins etc)?

MartinRichter
Автор

how can i create my own DBeaver Sample database??

mahdinouira