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

Editor to share with you what the SQL data-level operations are, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

DML (data manipulation language): they are SELECT, UPDATE, INSERT, DELETE, and are used to manipulate data.

Increase

Insert into table name values (value)

Insert into table name set field = value

Delete

Delete from table name where condition

Change

Update table name set field = new value where condition

Check

Select field from table name where condition order by DESC group by field having condition limit

Union query () union all ()

Subquery where field = [set relationship] select field

Internal join query inner join on (using)

External join query left (right) join on (using)

[set relationship] supplement

= any () is equivalent to in ()

! = all () is equivalent to not in ()

The above is all the contents of the article "what are the operations on the data plane of SQL?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.