test.script
资源名称:EXT_study.rar [点击查看]
上传用户:zaktkj
上传日期:2022-08-08
资源大小:5770k
文件大小:3k
源码类别:
JavaScript
开发平台:
JavaScript
- CREATE SCHEMA PUBLIC AUTHORIZATION DBA
- CREATE MEMORY TABLE STUDENT(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL,CODE VARCHAR(50),NAME VARCHAR(50),SEX INTEGER,AGE INTEGER,POLITICAL VARCHAR(50),ORIGIN VARCHAR(50),PROFESSIONAL VARCHAR(50),CONSTRAINT PK_STUDENT PRIMARY KEY(ID))
- ALTER TABLE STUDENT ALTER COLUMN ID RESTART WITH 17
- CREATE USER SA PASSWORD ""
- GRANT DBA TO SA
- SET WRITE_DELAY 10
- SET SCHEMA PUBLIC
- INSERT INTO STUDENT VALUES(1,'2002015','u5f20u5149u548c',1,21,'u56e2u5458','u6e56u5317u7701','u7269u6d41u5de5u7a0bu5b66u9662')
- INSERT INTO STUDENT VALUES(2,'2002002','u5f20u503cu5f3a',1,22,'u515au5458','u6cb3u5357u7701','u52a8u529bu5de5u7a0bu7cfb')
- INSERT INTO STUDENT VALUES(3,'2002003','u69d0 u5fc3',1,23,'u56e2u5458','u56dbu5dddu7701','u7ba1u7406u5b66u9662')
- INSERT INTO STUDENT VALUES(4,'2002004','u738bu5c0fu52c7',1,23,'u56e2u5458','u91cdu5e86u5e02','u6750u6599u5b66u9662')
- INSERT INTO STUDENT VALUES(5,'2002005','u738bu5386u5386',1,22,'u515au5458','u6cb3u5317u7701','u6587u6cd5u5b66u9662u7cfb')
- INSERT INTO STUDENT VALUES(6,'2002006','u5434u5b5fu8fbe',1,23,'u7fa4u4f17','u9999u6e2fu7279u522bu884cu653fu533a','u8ba1u7b97u673au5b66u9662')
- INSERT INTO STUDENT VALUES(7,'2002007','u91d1u5ae3u7ea2',2,22,'u56e2u5458','u5c71u897fu7701','u8ba1u7b97u673au5b66u9662')
- INSERT INTO STUDENT VALUES(8,'2002008','u5218u957fu8273',2,22,'u515au5458','u5317u4eacu5e02','u6570u7406u5b66u9662')
- INSERT INTO STUDENT VALUES(9,'2002009','u8bb8 u5f3a',2,23,'u56e2u5458','u5b89u5fbdu7701','u673au68b0u5b66u9662')
- INSERT INTO STUDENT VALUES(10,'2002010','u6768u5c0fu9e43',2,20,'u56e2u5458','u5e7fu897f','u6587u6cd5u5b66u9662')
- INSERT INTO STUDENT VALUES(11,'2002011','u5cb3u4e0du7fa4',1,25,'u515au5458','u5b89u5fbdu7701','u4f53u80b2u7cfb')
- INSERT INTO STUDENT VALUES(12,'2002012','u4efbu6211u884c',1,26,'u56e2u5458','u6c5fu82cfu7701','u673au68b0u5b66u9662')
- INSERT INTO STUDENT VALUES(13,'2002016','u5218 u6e20',1,24,'u56e2u5458','u9ed1u9f99u6c5fu7701','u73afu5883u5de5u7a0bu7cfb')
- INSERT INTO STUDENT VALUES(14,'2002014','u9ec4 u84c9',2,21,'u515au5458','u798fu5efau7701','u5916u8bedu7cfb')
- INSERT INTO STUDENT VALUES(15,'2002001','u738bu96e8u5ae3',2,20,'u7fa4u4f17','u6d59u6c5fu7701','u8ba1u7b97u673au5b66u9662')
- INSERT INTO STUDENT VALUES(16,'2002013','u4e54 u98ce',1,26,'u7fa4u4f17','u9752u6d77u7701','u7ee7u7eedu6559u80b2u5b66u9662')