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

Editor to share with you what are the common sentences in sql, 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!

Structured query language (Structured Query Language) is referred to as SQL. Structured query language is a database query and programming language for accessing data and querying, updating and managing relational database systems.

Sql statement is a language that operates on a database.

Program function

Create a database

CREATE DATABASE database-name

Delete database

Drop database dbname

Create a new table

Create table tabname (col1 type1 [not null] [primary key], col2 type2 [not null],..)

Delete new table

Drop table tabname

Common sentence

Updating: update table1 set field1=value1 where ran

Find: select * from table1 where field1 like'% value1%' (all strings that contain the pattern 'value1')

Sort: select * from table1 order by field1,field2 [desc]

Summation: select sum (field1) as sumvalue from table1

Average: select avg (field1) as avgvalue from table1

Maximum: select max (field1) as maxvalue from table1

Minimum: select min (field1) as minvalue from table1 [separator]

The above is all the content of the article "what are the common sentences in 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.