【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供CreateMyEssays.sql参考,解决您在CreateMyEssays.sql学习中工作中的难题,参考学习。
CREATE TABLE MYESSAYS (
EID INTEGER NOT NULL,
ETITLE VARCHAR(60),
MAGAZINE VARCHAR(60),
PDATE DATE,
CONTENTS BLOB sub_type 0 segment size 80,
NOTES VARCHAR(100));
INSERT INTO MYESSAYS (EID, ETITLE, MAGAZINE, PDATE, NOTES) VALUES (1, '2001年
软件巨星 - Kylix', 'RUN!PC 2001/3', '03/05/2001', NULL);
INSERT INTO MYESSAYS (EID, ETITLE, MAGAZINE, PDATE, NOTES) VALUES (2, 'Windows原生开发工具的瑰宝 -
Delphi 6', 'RUN!PC 2001/6', '05/05/2001', NULL);
INSERT INTO MYESSAYS (EID, ETITLE, MAGAZINE, PDATE, NOTES) VALUES (3, 'So much fun, So many possibilities', 'RUN!PC 2001/7', '06/05/2001', NULL);
INSERT INTO MYESSAYS (EID, ETITLE, MAGAZINE, PDATE, NOTES) VALUES (4, '肥皂的战争与和平', 'RUN!PC 2001/8', '07/05/2001', NULL);
INSERT INTO MYESSAYS (EID, ETITLE, MAGAZINE, PDATE, NOTES) VALUES (5, '.
NET的SOAP', 'RUN!PC 2001/9', '08/05/2001', NULL);
INSERT INTO MYESSAYS (EID, ETITLE, MAGAZINE, PDATE, NOTES) VALUES (990, '我的回忆和有趣的故事', 'Programmer深度论坛', '03/01/2001', NULL);
INSERT INTO MYESSAYS (EID, ETITLE, MAGAZINE, PDATE, NOTES) VALUES (991, '我的回忆和有趣的故事续之一', 'Programmer深度论坛', '04/01/2001', NULL);
ALTER TABLE MYESSAYS ADD PRIMARY KEY (EID);
CREATE INDEX MYESSAYS_IDX1 ON MYESSAYS (ETITLE);
CREATE INDEX MYESSAYS_IDX2 ON MYESSAYS (PDATE);