access表操作？

#選擇所有數(shù)據(jù)

SELECT *

FROM table_name;

#選擇不同的數(shù)據(jù)

SELECT DISTINCT column_name,column_name

FROM table_name;

#過濾

SELECT column_name,column_name

FROM table_name

WHERE column_name operator value;

#排序

SELECT column_name,column_name

FROM table_name

ORDER BY column_name,column_name ASC|DESC;

#插入數(shù)據(jù)

INSERT INTO table_name

VALUES (value1,value2,value3,...);

INSERT INTO table_name (column1,column2,column3,...)

VALUES (value1,value2,value3,...);

#更新

UPDATE table_name

SET column1=value1,column2=value2,...

WHERE some_column=some_value;

#刪除

DELETE FROM table_name

WHERE some_column=some_value;