解决方案 »
- 时间长后连接池清空,并且不能重新获取问题.
- Mysql 5.0中建立表之间关联的条件是什么,我这里为什么总是报错,请高手指点
- 如何把免安装的mysql5.1安装到指定的路径下?高手!
- 一篇文章可以属于多个专题,我在文章表里添加一个字段nvarchar(4000) 然后吧文章所属的专题的ID 用豆号分割? 这样写法好不好?
- mysql TO_DAYS函数的用法
- MySQL的最新版本是什么?
- Why we look this error !
- SQLServer里面的With嵌套循环,如何在MySQL中实现
- 求助 1054 - Unknown column '*' in 'where clause'的问题
- dump文件怎么附加
- mysql触发器
- 求大神解答远程连接的原理!
ORDERID NUMERIC(18) NOT NULL,
USERNAME VARCHAR(32),
AGE INTEGER,
GENDER DECIMAL(12,2),
BIRTHDAY DATE,
GRADE VARCHAR(20),
HOBBY VARCHAR(250),
CONSTRAINT PK_EDS_ORDER PRIMARY KEY (ORDERID)
);
-- Add comments to the columns
COMMENT ON COLUMN ORDERINFO.ORDERID
IS '订单ID';
COMMENT ON COLUMN ORDERINFO.USERNAME
IS '负责人';
COMMENT ON COLUMN ORDERINFO.ITEMCOUNT
IS '数量';
COMMENT ON COLUMN ORDERINFO.TOTALPRICE
IS '金额';
COMMENT ON COLUMN ORDERINFO.CREATEDATE
IS '下单日期';
COMMENT ON COLUMN ORDERINFO.ORDERSTATUS
IS '订单状态';
COMMENT ON COLUMN ORDERINFO.ORDERNOTE
IS '备注';
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (1, '张峰', 12, 2400, TO_DATE('17-07-2013', 'dd-mm-yyyy'), '1', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (2, '张宇', 15, 4680, TO_DATE('08-08-2013', 'dd-mm-yyyy'), '4', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (3, '王倩', 24, 8700, TO_DATE('02-10-2013', 'dd-mm-yyyy'), '3', '客户急需');
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (4, '王青', 35, 6500, TO_DATE('01-08-2013', 'dd-mm-yyyy'), '4', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (5, '陈刚', 23, 2560, TO_DATE('17-03-2013', 'dd-mm-yyyy'), '1', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (6, '谢宁', 18, 2135, TO_DATE('08-02-2013', 'dd-mm-yyyy'), '2', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (7, '陈胜强', 45, 6785, TO_DATE('02-12-2012', 'dd-mm-yyyy'), '3', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (8, '王青', 10, 1265, TO_DATE('01-06-2012', 'dd-mm-yyyy'), '4', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (9, '吴亚太', 21, 3325, TO_DATE('17-09-2013', 'dd-mm-yyyy'), '2', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (10, '李中正', 11, 2789, TO_DATE('28-01-2013', 'dd-mm-yyyy'), '4', NULL);
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (11, '李正', 22, 3408, TO_DATE('22-10-2013', 'dd-mm-yyyy'), '3', '注意高品质');
INSERT INTO ORDERINFO (ORDERID, USERNAME, ITEMCOUNT, TOTALPRICE, CREATEDATE, ORDERSTATUS, ORDERNOTE)
VALUES (12, '甄明', 36, 6532, TO_DATE('01-10-2013', 'dd-mm-yyyy'), '5', NULL);
DELETE FROM EOS_UNIQUE_TABLE WHERE NAME ='Orderinfo.orderid';
INSERT INTO EOS_UNIQUE_TABLE(NAME, CODE) VALUES('Orderinfo.orderid', 12);
DELETE FROM EOS_DICT_ENTRY WHERE DICTTYPEID ='OrderStatus';
DELETE FROM EOS_DICT_TYPE WHERE DICTTYPEID ='OrderStatus';INSERT INTO EOS_DICT_TYPE(DICTTYPEID,DICTTYPENAME,RANK) VALUES('OrderStatus','订单状态',1);INSERT INTO EOS_DICT_ENTRY(DICTTYPEID,DICTID,DICTNAME) VALUES('OrderStatus','1','待审核');
INSERT INTO EOS_DICT_ENTRY(DICTTYPEID,DICTID,DICTNAME) VALUES('OrderStatus','2','采购中');
INSERT INTO EOS_DICT_ENTRY(DICTTYPEID,DICTID,DICTNAME) VALUES('OrderStatus','3','验收中');
INSERT INTO EOS_DICT_ENTRY(DICTTYPEID,DICTID,DICTNAME) VALUES('OrderStatus','4','已完成');
INSERT INTO EOS_DICT_ENTRY(DICTTYPEID,DICTID,DICTNAME) VALUES('OrderStatus','5','已取消');
DROP TABLE ORDERINFO;cascade constraints 是oracle的写法