access数据库的常用语句有哪些?
新建表:create table [表名]( [自动编号字段] int identity (1,1) primary key , [字段1] nvarchar(50) default '默认值' ** , [字段2] ntext ** , [字段3] datetime, [字段4] money ** , [字段5] int default 0, [字段6] decimal (12,4) default 0, [字段7] image ** ,)删除表:drop table [表名]插入数据:insert into [表名] (字段1,字段2) values (100,'51windows.net')删除数据:delete from [表名] where [字段名]>100更新数据:update [表名] set [字段1] = 200,[字段2] = '51windows.net' where [字段三] = 'haiwa'新增字段:alter table [表名] add [字段名] nvarchar (50) **删除字段:alter table [表名] drop column [字段名]修改字段:alter table [表名] alter column [字段名] nvarchar (50) ** 20210311