Database common command and method SQL common command usage: (1) Data Record Filter: SQL = "SELECT * FROM DATA WHERE Field Name = Field Value ORDER BY Field Name" SQL = "SELECT * FROM DATA WHERE Field Name Like ' % Field Value% 'Order By Field Name "SQL =" SELECT TOP 10 * FROM Datasheet WHERE Field Name Order By Field Name "SQL =" SELECT * FROM DATA WHERE Field Name in (' value 1 ',' value 2 ' , 'Value 3') "SQL =" SELECT * FROM DATA WHERE Field Name BETWEEN Value 1 AND Value 2 "(2) Update Data Record: SQL =" Update Datasheet Set Field Name = Field Value Where Condition Expression "SQL = "Update Data Table SET Field 1 = Value 1, Field 2 = Value 2 ... Field N = Value N Where Condition Expression" (3) Delete Data Record: SQL = "Delete From Datasheet Where WHERE Condition Expression" SQL = "DELETE FROM Datasheet" (4) Add Data Record: SQL = "Insert INTO Data Sheet (Field 1, Field 2, Field 3 ...) VALUESS (value 1, value 2, value 3 ... "SQL =" INSERT INTO Target Data Table Select * FROM source data table "(Add record of source data table to the target data table) (5) Data logging statistics: AVG (field name) gives a table column average Count (* | field name) Statistics on the number of data lines or the number of data line counts for a value for a column get a table bar maximum value min (field name) to get the smallest value of a table bar SUM (Field Name) add the value of the value of the data bar to the above function: SQL = "Select SUM (field name) AS alias from data table where condition expression" SET RS = conn.excute (SQL) RS ("alias ") Get the value of the value, and other functions are used.
