test.script

来自「一个extjs编写的代码」· SCRIPT 代码 · 共 23 行

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE STUDENT(ID BIGINT,CODE VARCHAR(50),NAME VARCHAR(50),SEX VARCHAR(50),AGE INTEGER,POLITICAL VARCHAR(50),ORIGIN VARCHAR(50),PROFESSIONAL VARCHAR(50))
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10
SET SCHEMA PUBLIC
INSERT INTO STUDENT VALUES(1,'2002015','\u5f20\u5149\u548c','\u7537',21,'\u56e2\u5458','\u6e56\u5317\u7701','\u7269\u6d41\u5de5\u7a0b\u5b66\u9662')
INSERT INTO STUDENT VALUES(2,'2002002','\u5f20\u503c\u5f3a','\u7537',22,'\u515a\u5458','\u6cb3\u5357\u7701','\u52a8\u529b\u5de5\u7a0b\u7cfb')
INSERT INTO STUDENT VALUES(3,'2002003','\u69d0\u5fc3','\u7537',23,'\u56e2\u5458','\u56db\u5ddd\u7701','\u7ba1\u7406\u5b66\u9662')
INSERT INTO STUDENT VALUES(4,'2002004','\u738b\u5c0f\u52c7','\u7537',23,'\u56e2\u5458','\u91cd\u5e86\u5e02','\u6750\u6599\u5b66\u9662')
INSERT INTO STUDENT VALUES(5,'2002005','\u738b\u5386\u5386','\u5973',22,'\u515a\u5458','\u6cb3\u5317\u7701','\u6587\u6cd5\u5b66\u9662\u7cfb')
INSERT INTO STUDENT VALUES(6,'2002006','\u5434\u5b5f\u8fbe','\u7537',23,'\u65e0','\u9999\u6e2f\u7279\u522b\u884c\u653f\u533a','\u8ba1\u7b97\u673a\u5b66\u9662')
INSERT INTO STUDENT VALUES(7,'2002007','\u91d1\u5ae3\u7ea2','\u5973',22,'\u56e2\u5458','\u5c71\u897f\u7701','\u8ba1\u7b97\u673a\u5b66\u9662')
INSERT INTO STUDENT VALUES(8,'2002008','\u5218\u957f\u8273','\u5973',22,'\u515a\u5458','\u5317\u4eac\u5e02','\u6570\u7406\u5b66\u9662')
INSERT INTO STUDENT VALUES(9,'2002009','\u8bb8\u5f3a','\u7537',23,'\u56e2\u5458','\u5b89\u5fbd\u7701','\u673a\u68b0\u5b66\u9662')
INSERT INTO STUDENT VALUES(10,'2002010','\u6768\u5c0f\u9e43','\u5973',20,'\u56e2\u5458','\u5e7f\u897f','\u6587\u6cd5\u5b66\u9662')
INSERT INTO STUDENT VALUES(11,'2002011','\u5cb3\u4e0d\u7fa4','\u7537',25,'\u515a\u5458','\u5b89\u5fbd\u7701','\u4f53\u80b2\u7cfb')
INSERT INTO STUDENT VALUES(12,'2002012','\u4efb\u6211\u884c','\u7537',26,'\u56e2\u5458','\u6c5f\u82cf\u7701','\u673a\u68b0\u5b66\u9662')
INSERT INTO STUDENT VALUES(13,'2002016','\u5218\u6e20','\u7537',24,'\u56e2\u5458','\u9ed1\u9f99\u6c5f\u7701','\u73af\u5883\u5de5\u7a0b\u7cfb')
INSERT INTO STUDENT VALUES(14,'2002014','\u9ec4\u84c9','\u5973',21,'\u515a\u5458','\u798f\u5efa\u7701','\u5916\u8bed\u7cfb')
INSERT INTO STUDENT VALUES(15,'2002001','\u738b\u96e8\u5ae3','\u5973',20,'\u65e0','\u6d59\u6c5f\u7701','\u8ba1\u7b97\u673a\u5b66\u9662')
INSERT INTO STUDENT VALUES(16,'2002013','\u4e54\u98ce','\u7537',26,'\u65e0','\u9752\u6d77\u7701','\u7ee7\u7eed\u6559\u80b2\u5b66\u9662')