|
|
本帖最后由 通达林河水 于 2016-7-30 15:48 编辑 <br /><br /> 错误，请联系管理员 SQL语句: select sum(sheet_sz) as sz from crscell.crs_report where not find_in_set(kid, '{94FFE062-0E10-19EE-3554-E560A15FC082},{D1213FEF-B5ED-4A93-8A6D-EAFA02476D62},{E7662EA0-040A-CED4-B052-216947D7233C},{D0E97C01-A837-07FC-8EB8-5492D6990313},{0992AF0E-4E15-27CC-EFE6-6FE3FD88599B},{F790F9EB-B24D-0054-EFE6-6FE3FD88599B},{EB75C8CC-1BE1-58C5-6D94-3F4DE40C1190},{D4B7FEB1-3D15-29F4-EEC3-5A77BA4329AE},{1AC8761C-7873-FEB7-C334-58B5E1E84C00},{44F1DA8E-691C-6EB8-30BE-7FCB766B6D21},{4F656BAF-5B94-CF75-B848-8ADA1F29F131},{6398D666-9836-0D36-28C5-6426D4A9DCDA},{DBE4BEE1-0C77-5F66-E659-54643400464E},{DEAE113C-5542-2567-D038-08FD49378312},{FAA1E4B9-EC4B-779D-7523-9B212B060DA5},{D381A5FC-BD47-DE37-E51B-F06673A0344B},{25BC5FD0-E994-B004-B9CB-492C55E13968},{79F4AD78-98DA-A401-92A0-F80ACA37557C},{8EAA4A95-AB2C-BC42-E737-B4D55EF1A547},{6B787033-3CD0-7CE7-B95D-F5B50590B730},{2C719976-A366-3A11-3707-6C3D1D70DFF1},{B1D89A63-B20C-B900-134A-B399923BE4D0},{6A7244DD-150B-F47A-BA68-90A480F0FC97},{05651123-97D3-9618-483F-63B946D7EAFC},{6AE135DB-F7C9-E522-07E2-00C08450DB4B},{A0B1D8A5-FFD6-2035-80E1-083DC6720E8A},{83620EDC-59AE-2F1A-1A60-575CB2660842},{0B6ABBB2-E541-1A00-B241-03F6A5B9DF89},{FDE54B61-DCCC-DB6D-B4BE-5640209B471B},{89449344-3992-2503-B4BE-5640209B471B},{EF03DF61-F2CA-FF04-D8AC-EB952C00E84A},{AEF60A4B-316F-0889-5FF7-D970D9B3F517},{727024FA-9B3A-BFF1-7CCA-39B1D69217B0},{9069F054-FB06-75BE-7CCA-39B1D69217B0},{263C99EE-4041-018B-65CE-E6C0679E8859},{5A0C95B4-63C9-C2F7-A964-680783D75C94},{D8C938C0-C452-07F2-34E5-699EC61E66A2},{747651E1-B3A4-6699-B9A0-5C33FD6FA2DC},{DDEB2DAA-09D5-F7A5-3D2D-0674E6A89A80},{CE38AA8B-31D4-638C-CC5B-53377D2F9D18},{E2613657-0C5B-C842-4BD2-3D1146CB6B0D},{BDECC9C7-83CF-C0F8-9A92-6BFF8C869381},{CEF9785C-540B-F1A6-1956-04FD636E23DE},{7D948471-FAED-D51D-61C6-EE36A0B1F31A},{2E3A5DE1-9339-1525-47F1-692885548F66},{180FFAC8-CE4B-D892-895D-4CCDF45197A8},{388C5004-BDD7-0377-4ED4-617BD9FCE2D1},{F1E67F42-70C1-DE41-0863-5ED0A0935509},{D137D01B-91C9-76F1-975A-E122110A39E9},{504C3F6F-F95D-26CE-A61C-B230D25E5591},{D44740C7-7197-A7DD-3DB1-EC739ECBD79B},{9D9AC114-50A7-F803-3DB1-EC739ECBD79B},{1F6F8BC4-9B12-3534-4390-3F387EEFB3D3},{F8AD23CB-F5DE-689D-8C0E-850228FB6F40},{B61330F9-6428-A79E-2EBE-52A0ADB683C0},{B63840DF-D30D-A16F-8E9C-60B40E7746A8},{C25E0DC5-BE31-71FB-3AF1-E34FB6F454BB},{E5253AA1-9700-AAA9-4921-57B61FC12528},{01BE1222-E3AF-375B-BD99-302E24ED846B},{1B397015-91A9-2C80-D121-D9FBE8054D3D},{04C75BED-44DE-F6A6-2C3B-9D30586529C9},{67D4598A-9DF3-9AF9-D914-7696730D84EA},{D1B7F941-3A93-1919-E2BF-C8D96A14667B},{CE156D05-3822-4DD5-4057-D451E62080DF},{FC978809-3B46-90F1-26DA-C3CBA7FEB9A9},{43F2AD6C-C948-2BA8-9D25-0EBEC8743DB3},{94563183-D74F-219B-A269-94900E82FB4E},{B1D14C87-3A34-9E9A-F55C-0D9111A98474},{A848A305-CCB9-0C02-F55C-0D9111A98474},{F7AB45FA-7CCE-7D3A-F55C-0D9111A98474},{1E17257F-1627-3FD2-F55C-0D9111A98474},{48530CE2-C87E-5AFB-A98B-F66D80851149},{3D765A05-1B2D-7332-54C8-9CF8C847A20D},{A794F46E-4992-E217-546E-F8367A9B75E5},{B8BCFEF2-2EA4-28AE-1C1C-45C1D8BD916C},{124BC801-B909-4418-6B8E-722477FCBBEA},{C763A86D-E5E3-AB3C-8CEC-ABC5731863EF},{20821A2B-38E8-6C9A-3994-830699DD020A},{66E6E490-7767-9454-2BBC-E6CCE0222E7B},{261CC085-804F-E25B-B5C7-09414E5D03C2},{86361B62-D920-360C-CDFB-851E8AE790D3},{E1C4BCAC-E517-04C5-75DB-BCE2103777BB},{77AFA9C4-ABF8-416D-5ED9-A63D7B117E95},{389B73EA-64BF-60E2-01DE-FD0438A186C8},{F631487E-C4F9-4953-625D-3F8FC912CC4A},{687920C8-11E7-5CA8-2876-064A897AF26A},{9F4CBF15-00B7-D47F-7C0C-4DCD2BFB0091},{216F3513-7493-B2C3-7A6D-3F21F4F783C3},{F1561BFF-078F-6030-2E48-EAD404010C7F},{714E2118-3B25-2197-3A69-E8310EDC07D1},{3160CD47-8CFC-F49D-EF62-8FEC7BD76572},{E31F4F10-0AD9-5870-7963-B86EC8A3AD09},{FE4815E5-AE65-134E-E5E7-A345725EA73F},{6ABF17F2-C88D-89E5-FB2D-3DF423E21454},{622FD0D6-0B83-8AE7-F0E1-823FB452B04C},{DC7B4EBA-822F-A50A-B64E-CFADD64CD649},{D8D3D097-BA88-41A0-550D-E0ECC0A8E43E},{1C08A22D-F69D-D56F-7899-47CA597A82CF},{E3258D28-6D3A-002D-56F7-046F82397A92},{34AF4C65-9A58-A284-A780-EACB3C1AACE3},{47A5937E-5233-94C9-D853-BA533A731415},{FEEEC94A-50DF-3CDB-6D36-F94874DEF6A4},{2540CF7B-AE40-3379-BAE4-91BCFC38B667},{7F392D69-DF0E-6D2F-9997-2EB7C3F8977C},{7D32F185-A3B0-9052-06FE-9F36E0528CCB},{86DBCAFA-462B-C5C4-0BA7-3FF02F87D2B1},{F47F9D4B-53B6-3F1B-740C-B26D10F2B564},{CB491EA8-1469-A968-B460-3047BB42D269},{D7639872-A4B6-4459-25AF-2B4563E4930C},{E36AAC23-ECD8-7C92-FE00-215EC316DE7E},{0DF04095-B137-68FD-585D-0FECCA2E4144},{0E6F39D9-DA2C-3E30-ECB3-C9BCC744BB0F},{B750429E-7C58-E6E5-FE74-A7729A5796C8},{63A6B6AC-7CD8-6ED2-6E75-18797EA562E0},{F8BE2C88-1E80-8958-3540-30423BE2592B},{4BEFA200-F7C5-D61F-6763-C1410FF5911A},{2CAA3D67-24FC-DD5A-6714-BB43AF088467},{EF6E29DF-35AB-0D17-AE8A-6A5E3FFEBB79},{2D49A53E-4ECA-B64E-7434-CC2AB161F04C},{CEF4B5ED-637F-255B-2D1A-D8EF8D3F8104},{E2EC6C00-E4D4-5016-23B4-E1B1CDE035AD},{F301D95A-534F-3BC1-BA0E-2DCDF16D8D43},{297CACBC-3D86-43B5-0AF3-2D9959B18C3F},{EFDD7380-C0B2-F86E-1C5B-7AD781EEAD81},{91739CF2-B21D-B35D-5061-010D5E6145E3},{5E265003-500F-7544-1313-F48B287F955F},{4270BB1E-C180-D30C-7C00-DB57D02C9E74},{F6C70271-2629-CB44-06ED-2CE3D18B6CA0},{B3BB0BF2-6C1A-9B10-EF2B-891A643027A3},{107D7AED-0877-162D-9444-2F2633ACB6CA},{9A7402A6-1358-875F-C443-F5BF17B8F826},{64370430-4C0C-49D1-4DE9-190BA20463EC},{2E2924BA-5373-B2E9-094B-B4F2B0177DAF},{32D254AC-B7D8-D50C-CA9F-491A18AF746B},{4CD1D35D-003E-EAE5-3D36-40AE7DF7CC0D},{F356B1FF-4B16-F05F-EDE5-08BBAC0CC6C5},{98FBF179-706E-680A-AAB9-8622459C0971},{1996A450-8108-987D-4D67-DDE54DD3EEC7},{B27823DD-862B-C9DF-17E8-1DD707F19919},{75FEE9BE-2839-F177-EC5C-7E12FC520940},{FF841BE2-9321-3CD3-68BD-DDBB27A36124},{AE3F303E-A44C-8BAD-F62A-E862C6A04FDB},{F6F6D94C-3CBA-AA1C-EEA1-DAA0802429D2},{1EF46DCC-286E-6B23-8192-8E614A18C1BD},{B77DA455-E707-2D18-CE08-1B15823B8969},{6E334FDB-E3BD-55FF-9B3B-FFF759E1AC6D},{BF294EA2-5055-2406-8E5F-8C1575C4C264},{B49B211D-2F9D-3D02-87CA-60B3B983BADD},{0854B48E-35E9-BAA4-CBA3-48B6DCE7127E},{66FE071E-CF78-E719-C89C-8D8A339D14DE},{CF992AD5-A402-BDDF-4D4F-713CE411AF85},{08F32EF7-C7CB-199A-4ADF-44C8B8C565F8},{50AEB02C-48F0-0025-518A-9AA5D12DDDF3},{2C926C05-CE28-7CBD-97B1-EB4CC2FA8B12},{21DCE357-67F3-4473-DB7C-4A4A47558C36},{9667F615-564D-75B2-EFF7-F72DE7F5458C},{6111C139-EE2F-9F60-CE10-4001A76E773A},{9C65B5C7-4769-D372-B6D0-0D47F04A20B5},{4CF44708-CC47-119C-4CCD-3957F0C43451},{B1C10721-5526-37D6-83B0-495BCA9DE336},{9DED642C-9360-7A6D-472D-2216761ED35C},{BFAB4500-001B-8DDD-4EF7-A1A8FCDBC6FF},{689CB5D4-7921-1B48-AD4B-2B205872BCC6},{0AD62D8E-1BE3-5E25-057A-3A94517E9625},{32FD91F8-89D6-21E1-FBE4-0B62C401D092},{E36BCDD4-8827-D1F5-F1AF-7D6C9E70F589},{04F0AC05-A2E6-C62D-B71F-2D46C2DB7CC9},{739E91A6-1BBC-A490-CAD5-A9909EE747FD},{1F881116-C4BC-6EE5-9F25-498AF74E1DE5},{A5EB603F-5098-DB1A-278F-A9CF8DE35AE3},{10CE9DB6-6A60-BB9B-F7DF-65D77AC3B441},{95B3D79F-638E-5B39-FEEC-EA47896A591D},{3E4380D9-3C7B-19B8-A47B-7A72209E8F91},{66D940BE-499F-031E-A47B-7A72209E8F91},{6E15F5E7-8D49-451B-BC2D-2137B5F3CDF9},{799682D0-C06F-02B3-3A6E-72B87EDFE7DE},{AF61C9DB-9346-26F5-3A6E-72B87EDFE7DE},{0CF5D16E-A0AF-EC9D-3A6E-72B87EDFE7DE},{4B371893-63C6-BE6E-3A6E-72B87EDFE7DE},{351D964D-3E78-7412-9F7B-067A813B235D},{1CAEDD65-3330-6A06-9F7B-067A813B235D},{34F62969-9766-4B96-DE21-AED13678EB91},{2B417404-3922-15C6-AD79-66A9AD032D92},{F3F0BCDB-233D-C5A3-AD79-66A9AD032D92},{27C85451-D407-25D1-AD79-66A9AD032D92},{05C37F6B-CF91-B13D-AD79-66A9AD032D92},{5CA29603-00B5-0DFC-93B3-8338CC01D4AE},{E79BCF25-D256-696E-9F0B-F8CFADD34D99},{30CC1441-434C-D0BC-FACC-72403FE6FCF6},{CDAD86B1-9AF2-F8F7-3647-33C6C599FC89},{1E57BAE6-508C-8D46-E30E-151612FF1736},{8DE2F12B-2AF1-C5B8-E8A8-F7905D21A886},{C593EFFE-84E8-50F0-B086-7A4CE057C90C},{AA0A251F-9BB1-0D19-D9DE-06F22313C0D4},{AAB7089C-0B8B-1DC3-679C-A642D034CA61},{1CAEDD65-3330-6A06-3A6E-72B87EDFE7DE},{F3F0BCDB-233D-C5A3-3A6E-72B87EDFE7DE},{27C85451-D407-25D1-3A6E-72B87EDFE7DE},{05C37F6B-CF91-B13D-3A6E-72B87EDFE7DE},{303595BA-D85B-4122-9101-2B5D43D6BE94},{CBBE0526-09A2-8892-51F0-3B6BDCC58CCB},{288B13F5-98BD-A51D-F489-7A44D9D45B9B},{5BC5F4E6-B50F-8924-4D05-801826FD1B3C},{F64CC739-0638-4FE6-6E9A-AABC2E5EA624},{1D1B89D5-9FF3-89D8-A134-E7EB2F77C0BA},{D865D1E2-E17E-0081-222A-0F704AE94BC1},{8966E7E8-31D7-0190-C47D-D148F1A5EA68},{2A61D5DC-47E6-32EF-7F65-4D9992B4058D},{8B6679FB-EF3A-05C9-BAA9-165A6F711B72},{A0983D63-D156-F69F-6862-7A245753C700},{4E2FB6A6-6F3F-96BB-B738-9D345BF77A48},{10565B61-41AB-4DBF-B0AE-F4C088AF0B0A},{6E974E1B-9F3E-EDAF-C412-0838F7BA46C9},{01AC40D1-E110-477E-B52A-A9916484619E},{0E52D94B-2994-F411-7525-F4F364B7762D},{5E57A146-30D4-A79F-FAB8-937658A944B0},{57F9D424-93DF-BF56-CF0B-F7FCDE909FA7},{8C9202AC-52AB-CF74-E85C-CF0FC6819B2E},{4A8ED40C-25CD-1B1E-FFCE-7D9ED178E40C},{7F1D88EA-CE36-D376-8953-05DA8B6CCAC8},{22B11902-27B5-5B76-C095-DAF8674FBB72},{4423172B-C4C2-FBC0-1520-B643E7C5C362},{21911425-99ED-0CB1-E8BB-BD2811249B77},{742E6F26-1216-CA0C-1B84-9383F7B5C72B},{B85B4117-797E-48CE-FABC-09F846DCBB28},{FB676D95-F9B4-D615-B9D2-A1ACAC4C42E0},{02DA9C8F-5BA6-40D2-3238-8DAD38893D49},{7E53BC99-8B14-0991-146A-823D21D1A9D4},{FA80E3BC-1F5C-EFAA-C4F4-FAF2329E1378},{F37FF347-DAF7-F24C-3023-D9A2057C80D7},{81780495-10CE-A820-3BD5-5B6A240E9580},{471BC334-C3E2-EC58-01EF-99B3FBE0BFA3},{BADFD7EA-7ED6-6A95-514F-D2C724367DC0},{75EA27AA-690E-0DF0-5B81-E81DFF7FCCD3},{9F53315F-6705-D43B-FF84-DC5001CC0A22},{BB60E2D5-4DC5-3F8D-A7E7-3E514E2FFD1C},{9E6825F6-7063-70DC-DF40-E97692C398A4},{24F31512-3E03-A348-0FEE-7F990D777F6B},{12A21F0E-8F18-AA1B-FAFC-725F94467F45},{62C3DF89-52F8-6F1A-FF28-438B01E93D00},')
文件：/general/reportshop/design/report/add.php 错误，请联系管理员 SQL语句: insert into crscell.crs_report(kid, repno, repname, kindid, pw, sheet_sz) values('{28FBF324-2CAA-8C8D-EBBD-DABCD9D5544A}','TS01', '测试', '1', '1$02be1oX6p.A', '1')
文件：/general/reportshop/design/report/add.php |
|
[复制链接]
发表于 2014-12-4 15:23:53