What is difference between Update and Alter commands in SQL? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

What is difference between Update and Alter commands in SQL?

3rd Oct 2017, 1:54 PM
Zin Bo Thit
2 Answers
+ 4
Update is for change data information Alter is for change database struct
3rd Oct 2017, 1:58 PM
Daniel
Daniel - avatar
+ 2
Roland UPDATE is for do changes in data information in database and ALTER is for do changes in database struct, for delete or add fields or even to rename. For enter new data, new row information usually use INSERT
3rd Oct 2017, 2:04 PM
Daniel
Daniel - avatar