Shulou(Shulou.com)06/01 Report--

How does sql delete multiple pieces of data? This problem may be encountered in our daily work. Through this question, I hope you can gain more. If you don't look at the answer, I don't know if you are sure to answer this question. Let's try it.

Structured query language (Structured Query Language) is abbreviated as SQL (pronounced / pronounced es kju query el/ "S-Q-L"). It is a special purpose programming language, a database query and programming language, which is used to access data, query, update and manage relational database systems, as well as an extension of database script files.

How do I delete multiple records with a single sql statement?

For example, there is a line in the table where ID is a SQL, and delete the line whose ID number is abc with a line.

Answer: delete from table name where id in (a _ mae bjol c)

The above is the introduction of the method of deleting multiple pieces of data by sql, and you have to use it yourself to know the specific essentials. If you want to read more related articles, you are welcome to follow the industry information channel!

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.