数据库常用关键字（国外英文资料）.doc

数据库常用关键字（国外英文资料） Adoquery1. Fielddefs [1]. The Name; The field name Dbgrid1.columns [0].width: = 10; Dbgrid field width Adoquery1. Fields [I].datatype = ftString field type Update jb_spzl set kp_item_name = upper (kp_item_name) modifies a certain list in the database table Select * from master. Dbo. sysobjects, jm_barcode.dbo. users multiple library queries Adotable1.sort: = field name ASC adotable sort SQL statements are commonly seen Sp_password null, new password, sa modifies the database password (1) data recording screening: SQL = select * from data table where field name = field value orderby field name [desc] SQL = select * from data table where field name like % field value % orderby field name [desc] SQL = select top10 * from data table where field name [desc] SQL = select * from data table where field name in ( value 1 , value 2, value 3) SQL = select * from data table where field name between value 1 and 2 (2) updating data records: SQL = update data table set field name = field value where conditional expression SQL = update data table set field 1 = value 1, field 2 = value 2... field n = value n where condition expression (3) delete data records: SQL = delete from data table where condition expression SQL = delete from data table (delete all records from the data table) (4) adding data records: SQL = insert into data table (field 1, field 2, field 3...) values (value 1, value 2, value 3...) SQL = insert into target data table select * from source data table (add the record of the source data table to the target table) (5) data recording statistics function: The AVG (field name) yields a table bar average COUNT (* | field name) statistics on the number of data rows or data rows with values in a column MAX (field name) takes the maximum value of a table bar MIN (field name) takes the minimum value of a table column SUM (the field name) adds the value of the data column How to refer to the above functions: SQL = selectsum (field name) as alias from data ta