Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to insert and update data in SQL. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

In excel, we can insert and update data directly by double-clicking a table.

In the database, we can insert the data through insert into.

Running code: insert into emp (ename,sex) values ('Zhang San', 'male')

You can see that the insertion has been successful:

Query the data again:

At this point, our data insertion operation has been completed.

If we find that Zhang San's gender is wrong and we need to change it to a female, we can use the update statement to update the data.

Update emp set sex=' female 'where ename=' Zhang San'

Query again at this time:

By the same token, if we want to delete a piece of data, or some data, we can use the delete statement to delete:

Delete from emp where ename = 'Zhang San'

You can see that the data has changed. The operations of inserting, updating and deleting are called DML (Data Manipulation Language) data manipulation language in the database.

This is the end of the article on "how to insert and update data in SQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.