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

This article shows you what the Access database operation statements are, which are concise and easy to understand, which can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Brief introduction of Access Database Operation statement

Let me briefly introduce some operation statements for the Access database.

1. Insert new data: insert

Example: add 1, Xiaoming to the table name TestTable and column name ID,Name

Insert into TestTable (ID,Name) values (1, Xiaoming)

You can also not add column names, the system will automatically sort and add to the database, be sure to keep in mind that the number of data items does not exceed the number of columns in the database, otherwise an error will be reported.

Insert into TestTable values (1, Xiao Ming)

two。 Update data: updata

Example: change the Name with ID 1 to Xiaohong

Updata TestTable set Name= Little Red where ID=1

3. Delete specified data

Example: delete data with ID 1

Delete * from TestTable where ID=1

4. Get the data of the whole table

Select * from TestTable

5. Query data

Example: query data with ID 1

Select * from TestTable where ID=1

Example: query data of date range class

Select * from TestTable where [data1] > # "+ mindt+" # and [data1]

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.