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

What is the data deletion and update in the SQL statement? aiming at this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

1. Delete

1) Delete record Delete from table name where id = 'xx'

2) Delete all data and return to initialize the identity field. Truncate table table name

3) the difference between delete and truncate

A. truncate can bring the seed back to its original value.

B. Truncate cannot add conditions

C. Truncate cannot involve triggers

D. Truncate has much higher performance than delete.

two。 Update

1) basic update update table name set [column name] = 'value' where [column name] = 'value'

2) use it with replace-the 'star' in the name over the age of 19 is replaced by '★'.

Update table name set name = replace (name,' star', '★') where age > 19

This is the answer to the question about how to delete and update data in the SQL sentence. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.