ACCESS 数据库表建立

使用DBeaver软件进行建立和查询

-- TDMSN definition

-- Drop table

-- DROP TABLE TDMSN;

CREATE TABLE TDMSN (
	`NO` INTEGER DEFAULT 0 NOT NULL,
	MO VARCHAR(255),
	MSN VARCHAR(255),
	IMEI VARCHAR(255),
	`PrintSum` INTEGER DEFAULT 0,
	CONSTRAINT SYS_PK_10372 PRIMARY KEY (`NO`)
);
CREATE UNIQUE INDEX SYS_IDX_SYS_PK_10372_10373 ON TDMSN (`NO`);

ACCESS 数据库表插入

INSERT  INTO TDMSN VALUES (2,'123','123','123',2);

ACCESS 数据库表查询

SELECT `NO`, MO, MSN, IMEI, `PrintSum`
FROM TDMSN;

ACCESS 数据库表删除

DELETE FROM TDMSN;