access 数据库

access create table

CREATE TABLE MEMBERS
(ID AUTOINCREMENT,
USERNAME TEXT NOT NULL,
CHSUSERNAME TEXT NOT NULL,
INTRODUCTION MEMO,
CHSINTRODUCTION MEMO,
RESEARCHFIELD TEXT,
CHSRESEARCHFIEDL TEXT,
PHONE TEXT,
EMAIL TEXT,
STATUS YES/NO,
PRIMARY KEY(ID));

create table 时不能写default语句