Summary of SQL FOCUS statements

SQL statements are case insensitive

1, select Column name from table name//The statement if there are multiple fields, need to be separated by commas, the order of the fields in the SELECT statement determines the order of the field display of the query results; field names allow duplicates

2. Select DISTINCT column name from table name//distinct If there are multiple field names, then multiple fields are not duplicated

3, SELECT column name from table name WHERE column operator value//The value in the statement if it is a text type, you need to use single quotation marks, if it is a numeric type, do not use quotation marks

4. SELECT column name from table name order BY//default in ascending order (ASC), in descending order, you need to manually specify DESC

5. INSERT into table_name (column 1, column 2,...)  Values (value 1, value 2,....) By default, values are added to all fields when the column name is omitted

6. UPDATE Table name SET column name = new value WHERE Column name = value//update statement used to modify data in table

7. DELETE from table name WHERE column name = value//

Summary of SQL FOCUS statements