access建表及插入sql语句

2014-09-26 网页编程网 网页编程网

CREATE TABLE `invoices` (

`invoice_number` varchar(25) NOT NULL,

`customer_number` varchar(25) NOT NULL,

`due_payment` money NOT NULL,

[discount_payment_ due_date] date NOT NULL,

[ invoicesDate] date NOT NULL,

PRIMARY KEY (`invoice_number`)

);

INSERT INTO `invoices` VALUES ('921235', '121235', '6', #2014-09-28#, #2014-09-09#)

INSERT INTO `invoices` VALUES ('921236', '121236', '7', #2014-09-28#, #2014-09-29#)

阅读原文

阅读 4171

123 显示电脑版