Sqlite插入数据成功，但是导入到电脑上可视化工具打开后数据不全_course

为了验证是否成功，插入完成后紧接着查询当前表，数据与预期的是一样的。 目前疑惑的就是将.db文件导入电脑上面，用可视化工具打开，查看到的数据不全。 不知道各位有没有遇到过，请指点指点,先谢谢了qq:8

插入新数据前判断数据是否存在_course

sql insert语句插入前先判断是否有某几个字段值记录相同，这个怎么写sql语句 谢谢

64位win7 安装access2010（64位），WPS不能使用数据导入功能，提示未安装数据库引擎，求解决方法？_course

请各位大神帮忙，查了很多资料，在网上找了很多，都没有解决方案，在该技术论坛发帖实属无奈，请谅解。 原系统win7是32位的，安装32位的access2010使用起来没有问题，可以正常打开excel文件和wps表格文件并链接数据库文件；系统win7升级位64后，重新安装了access2010（64位）和excel（64位）还有wps2016个人版，可以在access里打开外部的excel文件，也能导入，但是不可以像之前一样的access和wps文件互相打开和导入数据，错误提示如下：向导无法访问文件“c:\新建文件夹\01.xlsx”中的信息。请确认文件存在且格式正确。 在wps中使用数据源选项卡打开其他的wps表格文件提示：文件连接失败，可能存在以下问题之一： 1.您选择了不被支持的文件格式或数据库。 2.当前文件已被打开。 3.未安装“Access 2010 数据库引擎” 请教各位大神这个是哪里的问题，是缺少什么插件吗，请教怎么解决?

协助本人设计一个实体关系图（ERD map）_course

具体要求如图，图片形式随意，希望简洁，清晰。 如可以请做出注释。

如何在数据库中分辨数据是哪种概率分布？_course

例如二项分布、正态分布，需要怎么在数据库（有庞大的数据）操作（思路、方法）呢？求详解，写论文

VMware Authorization Service 错误1067_course

 系统日志错误事件7031

SQLite3 有date_sub函数吗？_course

SQLite3 有date_sub函数吗？ 没有的话用什么替代。 ``` SELECT  UID, date_sub(date1,sort) as login_group, min(date1) as start_date1, max(date1) as end_date1, count(1) as continuous_days FROM (     SELECT      UID,     date1,     row_number() OVER(PARTITION BY UID order by date1) as sort     FROM user_login ) a GROUP BY UID,date_sub(date1,sort) ``` 帮忙用SQLite3重写下SQL语句。

数据库设计之概念结构设计--E-R图。_course

想请教下，这个图应该怎么画？感谢 设某医院数据库中有三个实体集，一是”科室”实体集，属性有科室编号、科室名称；二是”医生”实体集，属性有职工编号、姓名、性别；三是”医疗项目”实体集，属性有项目编号、项目名称、项目简介。 每个科室有多名医生，每名医生只能在一个科室工作； 每名医生可以参与多个医疗项目，每个医疗项目可以由多名医生参加； 每名医生参加某个医疗项目，都有参与该项目的时间。 根据上述语义画出ER图，要求图中画出实体及联系的属性并注明联系的类型；

Sql Server2008 R2一张表多少数据量合适？_course

数据表用的GUID，单表数据量千万以上查询感觉有点卡了，做DML操作时也没之前流畅，不知道是不是表结构没有设计好，还是数据量达到一定值的时候都会出现这种情况

关于数据库E-R图的小白问题，希望大佬指教_course

题目是这样的 我画的是这样的 我觉得我画的有些地方不太对，我还有一些地方也不太明白 在效力的位置和需要缴纳的费用是应该属于联系还是实体 还有队伍的队长确定是不是可以通过效力的位置得到，还是我应该在team再加个属性呢？ 希望大佬教教我

如果把大脑记忆比作数据库，人脑的索引好像不是很好啊_course

比如，很多事情其实是记住的，但是一下子回想不起来，但是通过一些提示，或者笔记就能回想起来。这个提示就好比是外界的索引。

oralce sql的运行顺序 子查询_course

sql: ``` select t.username,t.onuattr,t.* from radius_data_temp t where not exists(select '1' from radius_data a where t.username = a.username and t.onuattr=a.onuattr ) ; ``` 其中的子查询 ``` (select '1' from radius_data a where t.username = a.username and t.onuattr=a.onuattr ) ``` 问题描述：为什么在括号内可以用在外层的t表。我的认知里sql只能先运行括号内的sql，给括号外的表提供数据。这个sql可运行，但是具体的运行顺序不太懂。还希望有大哥能帮忙答疑，谢谢。

求大神SQL2008r2语句优化_course

SQL server 2008r2 现在日常操作是查询gfdsa表内的数据按日期保存到另外一个表的（为了后面去重用） 现在查询一次需要1分钟左右，怎么才优化到30秒以内，或者有什么好的思路 ``` use ccc select t.* from (select aa,bb,cc,dd, row_number() over (partition by bb order by bb desc) rn from ( select aa =CONVERT(nvarchar(max),DECRYPTBYKEY(aa)) , bb ,cc ,dd from ccc..[gfdsa]except select aa, bb ,cc ,dd from rfv..[qaw711]except select aa, bb ,cc ,dd from rfv..[qaw712]except select aa, bb ,cc ,dd from rfv..[qaeq717]except select aa, bb ,cc ,dd from rfv..[qase702]except select aa, bb ,cc ,dd from rfv..[qase703]except select aa, bb ,cc ,dd from rfv..[qase704]except select aa, bb ,cc ,dd from rfv..[qase705]except select aa, bb ,cc ,dd from rfv..[qase708] except select aa, bb ,cc ,dd from rfv..[qase709] except select aa, bb ,cc ,dd from rfv..[qase710] except select aa, bb ,cc ,dd from rfv..[qase711] except select aa, bb ,cc ,dd from rfv..[qase716] except select aa, bb ,cc ,dd from rfv..[qase718] except select aa, bb ,cc ,dd from rfv..[qase719] except select aa, bb ,cc ,dd from rfv..[qzew07yc] except select aa, bb ,cc ,dd from rfv..[qzsew710]except select aa, bb ,cc ,dd from rfv..[qzsew711]except select aa, bb ,cc ,dd from rfv..[qzsew712]except select aa, bb ,cc ,dd from rfv..[qzsew713]except select aa, bb ,cc ,dd from rfv..[qzsew715]except select aa, bb ,cc ,dd from rfv..[qzsew716]except select aa, bb ,cc ,dd from rfv..[qzsew720]except select aa, bb ,cc ,dd from tgb..[qzrdx713]except select aa, bb ,cc ,dd from tgb..[qxdes711]except select aa, bb ,cc ,dd from tgb..[qzxswa718]except select aa, bb ,cc ,dd from tgb..[qxswaz711]except select aa, bb ,cc ,dd from tgb..[qxswaz716]except select aa, bb ,cc ,dd from tgb..[qxswzs711]except select aa, bb ,cc ,dd from tgb..[qcdesx702]except select aa, bb ,cc ,dd from tgb..[qwsxcsxz715]except select aa, bb ,cc ,dd from tgb..[qwsxcsxz717]except select aa, bb ,cc ,dd from tgb..[qtxdw709]except select aa, bb ,cc ,dd from tgb..[qywsxa704]except select aa, bb ,cc ,dd from tgb..[quwsx627]except select aa, bb ,cc ,dd from tgb..[qixse708]except select aa, bb ,cc ,dd from tgb..[qoxde715]except select aa, bb ,cc ,dd from tgb..[qoxde716]except select aa, bb ,cc ,dd from tgb..[qoxde717]except select aa, bb ,cc ,dd from tgb..[qpswxa715]except select aa, bb ,cc ,dd from yhn..[qlwsxe2]except select aa, bb ,cc ,dd from yhn..[qkxdes718]except select aa, bb ,cc ,dd from ujm..[qjxdre626]except select aa, bb ,cc ,dd from ujm..[qhedxs710]except select aa, bb ,cc ,dd from ujm..[qhedxs715]except select aa, bb ,cc ,dd from ujm..[qhedxs717]except select aa, bb ,cc ,dd from okm..[qhygvd718]except select aa, bb ,cc ,dd from ijn..[qwsngf]except select aa, bb ,cc ,dd from ijn..[qfwsxcd712]except select aa, bb ,cc ,dd from ijn..[qfwsxcd715]except select aa, bb ,cc ,dd from ijn..[wqaszx711]except select aa, bb ,cc ,dd from ijn..[wsxcde709]except select aa, bb ,cc ,dd from ijn..[wbgtfvd705]except select aa, bb ,cc ,dd from ijn..[wsxaqzde710]except select aa, bb ,cc ,dd from ijn..[wsxaqzde711]except select aa, bb ,cc ,dd from ijn..[wsxaqzde719]except select aa, bb ,cc ,dd from ijn..[wedcftv708]except select aa, bb ,cc ,dd from ijn..[wedcftv715]except select aa, bb ,cc ,dd from ijn..[eswqazxs710]except select aa, bb ,cc ,dd from ijn..[esxwdcz627]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq705]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq708]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq708s?]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq709]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq711]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq712]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq713]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq716]except select aa, bb ,cc ,dd from ijn..[rwsxcdeq718]except select aa, bb ,cc ,dd from uhb..[tfrcvcde]except select aa, bb ,cc ,dd from uhb..[ygbtrfvcd]except select aa, bb ,cc ,dd from uhb..[uhnbecd712] ) as ss ) t where rn<=1000 and bb in('asd') ```

如何将查询结果中的自动填充行数据去掉（mssql）？_course

``` SELECT A.生产部门, A.去年累计入库数量, -- B.本年入库生产部门, B.本年累计入库数量, -- C.上月入库生产部门, C.上月累计入库数量, -- D.本月入库生产部门, D.本月累计入库数量, -- E.昨天生产部门, E.昨天总入库数, F.昨天入库生产部门, F.昨天入库物料编码, F.昨天入库物料名称, F.昨天入库规格型号, F.昨天累计入库数量 FROM ( SELECT t6.FNAME AS '生产部门', sum( t2.FREALQTY ) AS '去年累计入库数量' FROM T_PRD_INSTOCK t1 LEFT JOIN T_PRD_INSTOCKENTRY t2 ON t1.FID = t2.FID LEFT JOIN T_BD_MATERIAL t3 ON t2.FMATERIALID = t3.FMATERIALID LEFT JOIN T_BD_MATERIAL_L t4 ON t3.FMATERIALID = t4.FMATERIALID LEFT JOIN T_BD_DEPARTMENT t5 ON t2.FWORKSHOPID = t5.FDEPTID LEFT JOIN T_BD_DEPARTMENT_L t6 ON t5.FDEPTID = t6.FDEPTID WHERE DATEDIFF(year,t1.FDATE,GETDATE())=1 -- 去年-- GROUP BY t6.FNAME, t5.FNUMBER ) A LEFT JOIN ( SELECT t6.FNAME AS '本年入库生产部门', sum( t2.FREALQTY ) AS '本年累计入库数量' FROM T_PRD_INSTOCK t1 LEFT JOIN T_PRD_INSTOCKENTRY t2 ON t1.FID = t2.FID LEFT JOIN T_BD_MATERIAL t3 ON t2.FMATERIALID = t3.FMATERIALID LEFT JOIN T_BD_MATERIAL_L t4 ON t3.FMATERIALID = t4.FMATERIALID LEFT JOIN T_BD_DEPARTMENT t5 ON t2.FWORKSHOPID = t5.FDEPTID LEFT JOIN T_BD_DEPARTMENT_L t6 ON t5.FDEPTID = t6.FDEPTID WHERE DATEDIFF(year,t1.FDATE,GETDATE())=0 -- 今年-- GROUP BY t6.FNAME, t5.FNUMBER ) B ON A.生产部门 = B.本年入库生产部门 LEFT JOIN ( SELECT t6.FNAME AS '上月入库生产部门', SUM( t2.FREALQTY ) AS '上月累计入库数量' FROM T_PRD_INSTOCK t1 LEFT JOIN T_PRD_INSTOCKENTRY t2 ON t1.FID = t2.FID LEFT JOIN T_BD_MATERIAL t3 ON t2.FMATERIALID = t3.FMATERIALID LEFT JOIN T_BD_MATERIAL_L t4 ON t3.FMATERIALID = t4.FMATERIALID LEFT JOIN T_BD_DEPARTMENT t5 ON t2.FWORKSHOPID = t5.FDEPTID LEFT JOIN T_BD_DEPARTMENT_L t6 ON t5.FDEPTID = t6.FDEPTID WHERE DATEDIFF(month,t1.FDATE,GETDATE())=1 -- 上月 GROUP BY t6.FNAME, t5.FNUMBER ) C ON B.本年入库生产部门 = C.上月入库生产部门 LEFT JOIN ( SELECT t6.FNAME AS '本月入库生产部门', sum( t2.FREALQTY ) AS '本月累计入库数量' FROM T_PRD_INSTOCK t1 LEFT JOIN T_PRD_INSTOCKENTRY t2 ON t1.FID = t2.FID LEFT JOIN T_BD_MATERIAL t3 ON t2.FMATERIALID = t3.FMATERIALID LEFT JOIN T_BD_MATERIAL_L t4 ON t3.FMATERIALID = t4.FMATERIALID LEFT JOIN T_BD_DEPARTMENT t5 ON t2.FWORKSHOPID = t5.FDEPTID LEFT JOIN T_BD_DEPARTMENT_L t6 ON t5.FDEPTID = t6.FDEPTID WHERE DATEDIFF(month,t1.FDATE,GETDATE())=0 -- 本月-- GROUP BY t6.FNAME, t5.FNUMBER ) D ON C.上月入库生产部门 = D.本月入库生产部门 LEFT JOIN ( SELECT t6.FNAME AS '昨天生产部门', t5.FNUMBER AS '部门编码', SUM( t2.FREALQTY ) AS '昨天总入库数' FROM T_PRD_INSTOCK t1 LEFT JOIN T_PRD_INSTOCKENTRY t2 ON t1.FID = t2.FID LEFT JOIN T_BD_MATERIAL t3 ON t2.FMATERIALID = t3.FMATERIALID LEFT JOIN T_BD_MATERIAL_L t4 ON t3.FMATERIALID = t4.FMATERIALID LEFT JOIN T_BD_DEPARTMENT t5 ON t2.FWORKSHOPID = t5.FDEPTID LEFT JOIN T_BD_DEPARTMENT_L t6 ON t5.FDEPTID = t6.FDEPTID WHERE DATEDIFF( DAY, t1.FDATE, GETDATE ( ) ) = 1 -- 昨天 GROUP BY t6.FNAME, t5.FNUMBER ) E ON D.本月入库生产部门 = E.昨天生产部门 LEFT JOIN ( SELECT t6.FNAME AS '昨天入库生产部门', t3.FNUMBER AS '昨天入库物料编码', t4.FNAME AS '昨天入库物料名称', t4.FSPECIFICATION AS '昨天入库规格型号', sum( t2.FREALQTY ) AS '昨天累计入库数量' FROM T_PRD_INSTOCK t1 LEFT JOIN T_PRD_INSTOCKENTRY t2 ON t1.FID = t2.FID LEFT JOIN T_BD_MATERIAL t3 ON t2.FMATERIALID = t3.FMATERIALID LEFT JOIN T_BD_MATERIAL_L t4 ON t3.FMATERIALID = t4.FMATERIALID LEFT JOIN T_BD_DEPARTMENT t5 ON t2.FWORKSHOPID = t5.FDEPTID LEFT JOIN T_BD_DEPARTMENT_L t6 ON t5.FDEPTID = t6.FDEPTID WHERE DATEDIFF(day,t1.FDATE,GETDATE())=1 -- 昨天 GROUP BY t3.FNUMBER, t4.FNAME, t4.FSPECIFICATION, t6.FNAME, t5.FNUMBER ) F ON E.昨天生产部门 = F.昨天入库生产部门 ORDER BY 部门编码 ```

问题缓存和我的本地Laravel / PHP / Apache安装_course

<div class="post-text" itemprop="text"> <p>I've been developing websites for <strong>years</strong> with PHP(7.1)/Laravel (5.6) on my local (Windows) computer. I don't use XAMPP or anything - I install Apache &amp; PHP &amp; MySQL directly, configure them, etc.</p> <p>Then I deploy the sites onto my shared hosting provider on HostGator. Both my PC &amp; HostGator are pretty slow.</p> <p>Yesterday I started playing with laravel Cache::. I put lots into the cache, played with different drivers - file, database, &amp; now Redis. But the more I use the Laravel Cache on my computer, the slower it gets - now insanely slow.</p> <p>BUT! I deploy the exact same code up to the Hostgator site, using just the default file cache driver, and suddenly it's like 3 times faster!</p> <p>Since the code &amp; PHP version are the same on my PC as Hostgator, I can only imagine it's either because HostGator is CentOS &amp; I'm windows 10, OR, something with how I configured my PHP or Apache that makes them play really badly with caching. Any quick thoughts? Even Redis didn't help!</p> <blockquote> <p>I'm including the output from phpinfo below:</p> </blockquote> <pre><code>PHP Version 7.1.4 System Windows NT BONDI 6.2 build 9200 (Windows 8 Home Premium Edition) AMD64 Build Date Apr 11 2017 19:50:45 Compiler MSVC14 (Visual C++ 2015) Architecture x64 Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-pdo-oci=c:\php-sdk\oracle\x64\instantclient_12_1\sdk,shared" "--with-oci8-12c=c:\php-sdk\oracle\x64\instantclient_12_1\sdk,shared" "--enable-object-out-dir=../obj/" "--enable-com-dotnet=shared" "--with-mcrypt=static" "--without-analyzer" "--with-pgo" Server API Apache 2.0 Handler Virtual Directory Support enabled Configuration File (php.ini) Path C:\WINDOWS Loaded Configuration File C:\App\php-7\php.ini Scan this dir for additional .ini files (none) Additional .ini files parsed (none) PHP API 20160303 PHP Extension 20160303 Zend Extension 320160303 Zend Extension Build API320160303,TS,VC14 PHP Extension Build API20160303,TS,VC14 Debug Build no Thread Safety enabled Zend Signal Handling disabled Zend Memory Manager enabled Zend Multibyte Support provided by mbstring IPv6 Support enabled DTrace Support disabled Zend Engine v3.1.0, Copyright (c) 1998-2017 Zend Technologies with Xdebug v2.6.0, Copyright (c) 2002-2018, by Hostname:Port localhost:80 Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 60 - Keep-Alive: 5 Virtual Server No Server Root C:/App/Apache24 Loaded Modules core mod_win32 mpm_winnt http_core mod_so mod_access_compat mod_actions mod_alias mod_allowmethods mod_asis mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dir mod_env mod_http2 mod_headers mod_include mod_isapi mod_log_config mod_mime mod_negotiation mod_rewrite mod_setenvif mod_socache_shmcb mod_ssl mod_php7 Directive Local Value Master Value engine 1 1 last_modified 0 0 xbithack 0 0 Apache Environment Variable Value HTTP_HOST localhost HTTP_CONNECTION keep-alive HTTP_UPGRADE_INSECURE_REQUESTS 1 HTTP_DNT 1 HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36 HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 HTTP_REFERER http://localhost/ HTTP_ACCEPT_ENCODING gzip, deflate, br HTTP_ACCEPT_LANGUAGE en-US,en;q=0.9,da;q=0.8 SystemRoot C:\WINDOWS COMSPEC C:\WINDOWS\system32\cmd.exe PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC WINDIR C:\WINDOWS SERVER_SIGNATURE no value SERVER_SOFTWARE Apache/2.4.23 (Win64) OpenSSL/1.0.2h PHP/7.1.4 SERVER_NAME localhost SERVER_ADDR ::1 SERVER_PORT 80 REMOTE_ADDR ::1 DOCUMENT_ROOT C:/App/Apache24/htdocs REQUEST_SCHEME http CONTEXT_PREFIX no value CONTEXT_DOCUMENT_ROOT C:/App/Apache24/htdocs SERVER_ADMIN pkirkaas@gmail.com SCRIPT_FILENAME C:/App/Apache24/htdocs/phpinfo.php REMOTE_PORT 2427 GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /phpinfo.php SCRIPT_NAME /phpinfo.php HTTP Headers Information HTTP Request Headers HTTP Request GET /phpinfo.php HTTP/1.1 Host localhost Connection keep-alive Upgrade-Insecure-Requests 1 DNT 1 User-Agent Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36 Accept text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Referer http://localhost/ Accept-Encoding gzip, deflate, br Accept-Language en-US,en;q=0.9,da;q=0.8 HTTP Response Headers X-Powered-By PHP/7.1.4 bcmath BCMath support enabled Directive Local Value Master Value bcmath.scale 0 0 calendar Calendar support enabled Core PHP Version 7.1.4 Directive Local Value Master Value allow_url_fopen On On allow_url_include Off Off arg_separator.input &amp; &amp; arg_separator.output &amp; &amp; auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap no value no value default_charset UTF-8 UTF-8 default_mimetype text/html text/html disable_classes no value no value disable_functions no value no value display_errors On On display_startup_errors On On doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl Off Off enable_post_data_reading On On error_append_string no value no value error_log C:/tmp/php_errors.log C:/tmp/php_errors.log error_prepend_string no value no value error_reporting 32767 32767 expose_php On On extension_dir C:/App/php-7.1.4-Win32-VC14-x64/ext/ C:/App/php-7.1.4-Win32-VC14-x64/ext/ file_uploads On On hard_timeout 2 2 highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors Off Off ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .;C:\php\pear .;C:\php\pear input_encoding no value no value internal_encoding no value no value log_errors On On log_errors_max_len 1024 1024 mail.add_x_header On On mail.force_extra_parameters no value no value mail.log no value no value max_execution_time 5260 5260 max_file_uploads 20 20 max_input_nesting_level 64 64 max_input_time 260 260 max_input_vars 1000 1000 memory_limit 1999M 1999M open_basedir no value no value output_buffering 4096 4096 output_encoding no value no value output_handler no value no value post_max_size 120M 120M precision 14 14 realpath_cache_size 16M 16M realpath_cache_ttl 120 120 register_argc_argv Off Off report_memleaks On On report_zend_debug On On request_order GP GP sendmail_from no value no value sendmail_path no value no value serialize_precision 17 17 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off sys_temp_dir no value no value track_errors On On unserialize_callback_func no value no value upload_max_filesize 120M 120M upload_tmp_dir no value no value user_dir no value no value user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order GPCS GPCS windows.show_crt_warning Off Off xmlrpc_error_number 0 0 xmlrpc_errors Off Off zend.assertions 1 1 zend.detect_unicode On On zend.enable_gc On On zend.multibyte Off Off zend.script_encoding no value no value ctype ctype functions enabled curl cURL support enabled cURL Information 7.53.1 Age 3 Features AsynchDNS Yes CharConv No Debug No GSS-Negotiate No IDN Yes IPv6 Yes krb4 No Largefile Yes libz Yes NTLM Yes NTLMWB No SPNEGO Yes SSL Yes SSPI Yes TLS-SRP No HTTP2 Yes GSSAPI No KERBEROS5 Yes UNIX_SOCKETS No PSL No Protocols dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, pop3, pop3s, rtsp, scp, sftp, smtp, smtps, telnet, tftp Host x86_64-pc-win32 SSL Version OpenSSL/1.0.2h ZLib Version 1.2.8 libSSH Version libssh2/1.8.0 date date/time support enabled "Olson" Timezone Database Version 2017.2 Timezone Database internal Default timezone UTC Directive Local Value Master Value date.default_latitude 31.7667 31.7667 date.default_longitude 35.2333 35.2333 date.sunrise_zenith 90.583333 90.583333 date.sunset_zenith 90.583333 90.583333 date.timezone no value no value dom DOM/XML enabled DOM/XML API Version 20031129 libxml Version 2.9.4 HTML Support enabled XPath Support enabled XPointer Support enabled Schema Support enabled RelaxNG Support enabled exif EXIF Support enabled EXIF Version 1.4 $Id: 8bdc0c8f27c2c9dd1f7551f1f9fe3ab57a06a4b1 $ Supported EXIF Version 0220 Supported filetypes JPEG,TIFF Directive Local Value Master Value exif.decode_jis_intel JIS JIS exif.decode_jis_motorola JIS JIS exif.decode_unicode_intel UCS-2LE UCS-2LE exif.decode_unicode_motorola UCS-2BE UCS-2BE exif.encode_jis no value no value exif.encode_unicode ISO-8859-15 ISO-8859-15 fileinfo fileinfo support enabled version 1.0.5 libmagic 522 filter Input Validation and Filtering enabled Revision $Id: cdc5e15bb616f10210b94ecd8789e66c927a375f $ Directive Local Value Master Value filter.default unsafe_raw unsafe_raw filter.default_flags no value no value gd GD Support enabled GD Version bundled (2.1.0 compatible) FreeType Support enabled FreeType Linkage with freetype FreeType Version 2.7.0 GIF Read Support enabled GIF Create Support enabled JPEG Support enabled libJPEG Version 9 compatible PNG Support enabled libPNG Version 1.6.21 WBMP Support enabled XPM Support enabled libXpm Version 30512 XBM Support enabled WebP Support enabled Directive Local Value Master Value gd.jpeg_ignore_warning 1 1 gettext GetText Support enabled hash hash support enabled Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512/224 sha512/256 sha512 sha3-224 sha3-256 sha3-384 sha3-512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 MHASH support Enabled MHASH API Version Emulated Support iconv iconv support enabled iconv implementation "libiconv" iconv library version 1.15 Directive Local Value Master Value iconv.input_encoding no value no value iconv.internal_encoding no value no value iconv.output_encoding no value no value imap IMAP c-Client Version 2007f SSL Support enabled intl Internationalization support enabled version 1.1.0 ICU version 57.1 ICU Data version 57.1 Directive Local Value Master Value intl.default_locale no value no value intl.error_level 0 0 intl.use_exceptions 0 0 json json support enabled json version 1.5.0 ldap LDAP Support enabled RCS Version $Id: 1a2168f979730c42ec291285f5183076688f4509 $ Total Links 0/unlimited API Version 3001 Vendor Name OpenLDAP Vendor Version 20444 SASL Support Enabled Directive Local Value Master Value ldap.max_links Unlimited Unlimited libxml libXML support active libXML Compiled Version 2.9.4 libXML Loaded Version 20904 libXML streams enabled mbstring Multibyte Support enabled Multibyte string engine libmbfl HTTP input encoding translation disabled libmbfl version 1.3.2 oniguruma version 5.9.6 mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1. Multibyte (japanese) regex support enabled Multibyte regex (oniguruma) version 5.9.6 Directive Local Value Master Value mbstring.detect_order no value no value mbstring.encoding_translation Off Off mbstring.func_overload 0 0 mbstring.http_input no value no value mbstring.http_output no value no value mbstring.http_output_conv_mimetypes ^(text/|application/xhtml\+xml) ^(text/|application/xhtml\+xml) mbstring.internal_encoding no value no value mbstring.language neutral neutral mbstring.strict_detection Off Off mbstring.substitute_character no value no value mcrypt mcrypt support enabled mcrypt_filter support enabled Version 2.5.8 Api No 20021217 Supported ciphers cast-128 gost rijndael-128 twofish cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes arcfour Supported modes cbc cfb ctr ecb ncfb nofb ofb stream Directive Local Value Master Value mcrypt.algorithms_dir no value no value mcrypt.modes_dir no value no value mysqli MysqlI Support enabled Client API library version mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $ Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket no value no value mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off mysqli.rollback_on_cached_plink Off Off mysqlnd mysqlnd enabled Version mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $ Compression supported core SSL supported extended SSL not supported Command buffer size 4096 Read buffer size 32768 Read timeout 31536000 Collecting statistics Yes Collecting memory statistics Yes Tracing n/a Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password API Extensions mysqli,pdo_mysql mysqlnd statistics bytes_sent 73072 bytes_received 1229046 packets_sent 2578 packets_received 15941 protocol_overhead_in 63764 protocol_overhead_out 10312 bytes_received_ok_packet 0 bytes_received_eof_packet 0 bytes_received_rset_header_packet 11322 bytes_received_rset_field_meta_packet 0 bytes_received_rset_row_packet 2233 bytes_received_prepare_response_packet 812313 bytes_received_change_user_packet 394029 packets_sent_command 1287 packets_received_ok 0 packets_received_eof 0 packets_received_rset_header 1258 packets_received_rset_field_meta 0 packets_received_rset_row 430 packets_received_prepare_response 11023 packets_received_change_user 2798 result_set_queries 423 non_result_set_queries 7 no_index_used 13 bad_index_used 0 slow_queries 0 buffered_sets 0 unbuffered_sets 0 ps_buffered_sets 423 ps_unbuffered_sets 0 flushed_normal_sets 0 flushed_ps_sets 0 ps_prepared_never_executed 0 ps_prepared_once_executed 428 rows_fetched_from_server_normal 0 rows_fetched_from_server_ps 2375 rows_buffered_from_client_normal 0 rows_buffered_from_client_ps 2375 rows_fetched_from_client_normal_buffered 0 rows_fetched_from_client_normal_unbuffered 0 rows_fetched_from_client_ps_buffered 2375 rows_fetched_from_client_ps_unbuffered 0 rows_fetched_from_client_ps_cursor 0 rows_affected_normal 0 rows_affected_ps 0 rows_skipped_normal 0 rows_skipped_ps 2375 copy_on_write_saved 0 copy_on_write_performed 0 command_buffer_too_small 0 connect_success 2 connect_failure 0 connection_reused 0 reconnect 0 pconnect_success 0 active_connections 0 active_persistent_connections 0 explicit_close 1 implicit_close 0 disconnect_close 0 in_middle_of_command_close 0 explicit_free_result 851 implicit_free_result 0 explicit_stmt_close 428 implicit_stmt_close 0 mem_emalloc_count 21107 mem_emalloc_amount 16715406 mem_ecalloc_count 15711 mem_ecalloc_amount 4021976 mem_erealloc_count 6068 mem_erealloc_amount 3403496 mem_efree_count 36818 mem_efree_amount 20862820 mem_malloc_count 0 mem_malloc_amount 0 mem_calloc_count 0 mem_calloc_amount 0 mem_realloc_count 0 mem_realloc_amount 0 mem_free_count 0 mem_free_amount 0 mem_estrndup_count 11 mem_strndup_count 0 mem_estrdup_count 8 mem_strdup_count 0 mem_edupl_count 0 mem_dupl_count 0 proto_text_fetched_null 0 proto_text_fetched_bit 0 proto_text_fetched_tinyint 0 proto_text_fetched_short 0 proto_text_fetched_int24 0 proto_text_fetched_int 0 proto_text_fetched_bigint 0 proto_text_fetched_decimal 0 proto_text_fetched_float 0 proto_text_fetched_double 0 proto_text_fetched_date 0 proto_text_fetched_year 0 proto_text_fetched_time 0 proto_text_fetched_datetime 0 proto_text_fetched_timestamp 0 proto_text_fetched_string 0 proto_text_fetched_blob 0 proto_text_fetched_enum 0 proto_text_fetched_set 0 proto_text_fetched_geometry 0 proto_text_fetched_other 0 proto_binary_fetched_null 0 proto_binary_fetched_bit 533 proto_binary_fetched_tinyint 0 proto_binary_fetched_short 1156 proto_binary_fetched_int24 0 proto_binary_fetched_int 0 proto_binary_fetched_bigint 10240 proto_binary_fetched_decimal 0 proto_binary_fetched_float 3 proto_binary_fetched_double 0 proto_binary_fetched_date 0 proto_binary_fetched_year 288 proto_binary_fetched_time 0 proto_binary_fetched_datetime 0 proto_binary_fetched_timestamp 0 proto_binary_fetched_string 4340 proto_binary_fetched_json 3384 proto_binary_fetched_blob 215 proto_binary_fetched_enum 0 proto_binary_fetched_set 0 proto_binary_fetched_geometry 0 proto_binary_fetched_other 0 init_command_executed_count 0 init_command_failed_count 0 com_quit 1 com_init_db 0 com_query 2 com_field_list 0 com_create_db 0 com_drop_db 0 com_refresh 0 com_shutdown 0 com_statistics 0 com_process_info 0 com_connect 0 com_process_kill 0 com_debug 0 com_ping 0 com_time 0 com_delayed_insert 0 com_change_user 0 com_binlog_dump 0 com_table_dump 0 com_connect_out 0 com_register_slave 0 com_stmt_prepare 428 com_stmt_execute 428 com_stmt_send_long_data 0 com_stmt_close 428 com_stmt_reset 0 com_stmt_set_option 0 com_stmt_fetch 0 com_deamon 0 bytes_received_real_data_normal 0 bytes_received_real_data_ps 420039 openssl OpenSSL support enabled OpenSSL Library Version OpenSSL 1.0.2h 3 May 2016 OpenSSL Header Version OpenSSL 1.0.2k 26 Jan 2017 Openssl default config /usr/local/ssl/openssl.cnf Directive Local Value Master Value openssl.cafile no value no value openssl.capath no value no value pcre PCRE (Perl Compatible Regular Expressions) Support enabled PCRE Library Version 8.38 2015-11-23 PCRE JIT Support enabled Directive Local Value Master Value pcre.backtrack_limit 1000000 1000000 pcre.jit 1 1 pcre.recursion_limit 100000 100000 PDO PDO support enabled PDO drivers mysql, odbc, sqlite pdo_mysql PDO Driver for MySQL enabled Client API version mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $ PDO_ODBC PDO Driver for ODBC (Win32) enabled ODBC Connection Pooling Enabled, strict matching pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.15.1 Phar Phar: PHP Archive support enabled Phar EXT version 2.0.2 Phar API version 1.1.1 SVN revision $Id: 59c11f4e29768bfbbf6f41cb469abd81d8655850 $ Phar-based phar archives enabled Tar-based phar archives enabled ZIP-based phar archives enabled gzip compression enabled bzip2 compression disabled (install pecl/bz2) OpenSSL support enabled Phar based on pear/PHP_Archive, original concept by Davey Shafik. Phar fully realized by Gregory Beaver and Marcus Boerger. Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle. Directive Local Value Master Value phar.cache_list no value no value phar.readonly On On phar.require_hash On On readline Readline Support enabled Readline library WinEditLine Directive Local Value Master Value cli.pager no value no value cli.prompt \b \&gt; \b \&gt; Reflection Reflection enabled Version $Id: a06522d025b0af3e6ba10a0f6964086b7e6f5458 $ session Session Support enabled Registered save handlers files user Registered serializer handlers php_serialize php php_binary wddx Directive Local Value Master Value session.auto_start Off Off session.cache_expire 180 180 session.cache_limiter nocache nocache session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path / / session.cookie_secure Off Off session.gc_divisor 1000 1000 session.gc_maxlifetime 1440 1440 session.gc_probability 1 1 session.lazy_write On On session.name PHPSESSID PHPSESSID session.referer_check no value no value session.save_handler files files session.save_path no value no value session.serialize_handler php php session.sid_bits_per_character 4 4 session.sid_length 32 32 session.upload_progress.cleanup On On session.upload_progress.enabled On On session.upload_progress.freq 1% 1% session.upload_progress.min_freq 1 1 session.upload_progress.name PHP_SESSION_UPLOAD_PROGRESS PHP_SESSION_UPLOAD_PROGRESS session.upload_progress.prefix upload_progress_ upload_progress_ session.use_cookies On On session.use_only_cookies On On session.use_strict_mode Off Off session.use_trans_sid 0 0 SimpleXML Simplexml support enabled Revision $Id: 7e5516dcdf2fe6ded7970eaeb6abd8d07df39a2a $ Schema support enabled soap Soap Client enabled Soap Server enabled Directive Local Value Master Value soap.wsdl_cache 1 1 soap.wsdl_cache_dir /tmp /tmp soap.wsdl_cache_enabled 1 1 soap.wsdl_cache_limit 5 5 soap.wsdl_cache_ttl 86400 86400 sockets Sockets Support enabled SPL SPL support enabled Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException standard Dynamic Library Support enabled Internal Sendmail Support for Windows enabled Directive Local Value Master Value assert.active 1 1 assert.bail 0 0 assert.callback no value no value assert.exception 0 0 assert.quiet_eval 0 0 assert.warning 1 1 auto_detect_line_endings 0 0 default_socket_timeout 60 60 from no value no value session.trans_sid_hosts no value no value session.trans_sid_tags a=href,area=href,frame=src,form= a=href,area=href,frame=src,form= url_rewriter.hosts no value no value url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry user_agent no value no value tokenizer Tokenizer Support enabled wddx WDDX Support enabled WDDX Session Serializer enabled xdebug xdebug support enabled Version 2.6.0 IDE Key BONDI$ Supported protocols DBGp - Common DeBuGger Protocol Directive Local Value Master Value xdebug.auto_trace Off Off xdebug.cli_color 0 0 xdebug.collect_assignments Off Off xdebug.collect_includes On On xdebug.collect_params 0 0 xdebug.collect_return Off Off xdebug.collect_vars Off Off xdebug.coverage_enable On On xdebug.default_enable On On xdebug.dump.COOKIE no value no value xdebug.dump.ENV no value no value xdebug.dump.FILES no value no value xdebug.dump.GET no value no value xdebug.dump.POST no value no value xdebug.dump.REQUEST no value no value xdebug.dump.SERVER no value no value xdebug.dump.SESSION no value no value xdebug.dump_globals On On xdebug.dump_once On On xdebug.dump_undefined Off Off xdebug.extended_info On On xdebug.file_link_format no value no value xdebug.filename_format no value no value xdebug.force_display_errors Off Off xdebug.force_error_reporting 0 0 xdebug.gc_stats_enable Off Off xdebug.gc_stats_output_dir C:\Windows\Temp C:\Windows\Temp xdebug.gc_stats_output_name gcstats.%p gcstats.%p xdebug.halt_level 0 0 xdebug.idekey no value no value xdebug.max_nesting_level 256 256 xdebug.max_stack_frames -1 -1 xdebug.overload_var_dump 2 2 xdebug.profiler_aggregate Off Off xdebug.profiler_append Off Off xdebug.profiler_enable Off Off xdebug.profiler_enable_trigger On On xdebug.profiler_enable_trigger_value no value no value xdebug.profiler_output_dir C:\tmp C:\tmp xdebug.profiler_output_name cachegrind.out.callgrind.%t-%s.out cachegrind.out.callgrind.%t-%s.out xdebug.remote_addr_header no value no value xdebug.remote_autostart Off Off xdebug.remote_connect_back Off Off xdebug.remote_cookie_expire_time 3600 3600 xdebug.remote_enable Off Off xdebug.remote_handler dbgp dbgp xdebug.remote_host localhost localhost xdebug.remote_log no value no value xdebug.remote_mode req req xdebug.remote_port 9000 9000 xdebug.remote_timeout 200 200 xdebug.scream Off Off xdebug.show_error_trace Off Off xdebug.show_exception_trace Off Off xdebug.show_local_vars Off Off xdebug.show_mem_delta Off Off xdebug.trace_enable_trigger Off Off xdebug.trace_enable_trigger_value no value no value xdebug.trace_format 0 0 xdebug.trace_options 0 0 xdebug.trace_output_dir C:\Windows\Temp C:\Windows\Temp xdebug.trace_output_name trace.%c trace.%c xdebug.var_display_max_children 128 128 xdebug.var_display_max_data 512 512 xdebug.var_display_max_depth 3 3 CommonProgramW6432 C:\Program Files\Common Files COMPUTERNAME BONDI ComSpec C:\WINDOWS\system32\cmd.exe CYGWIN mintty DriverData C:\Windows\System32\Drivers\DriverData GOPATH Q:\Common\Backups\Golangs GOROOT C:\App\Go JAVA_HOME C:\Program Files\Java\jdk-10.0.2 LANG en_US.UTF-8 LOCALAPPDATA C:\WINDOWS\system32\config\systemprofile\AppData\Local MOD_WSGI_APACHE_ROOTDIR C:/App/Apache24 NUMBER_OF_PROCESSORS 8 OnlineServices Online Services OS Windows_NT </code></pre> </div>

专为程序员设计的数学课_course

<p> 限时福利限时福利，<span>15000+程序员的选择！</span> </p> <p> 购课后添加学习助手（微信号：csdn590），按提示消息领取编程大礼包！并获取讲师答疑服务！ </p> <p> <br> </p> <p> 套餐中一共包含5门程序员必学的数学课程（共47讲） </p> <p> 课程1：《零基础入门微积分》 </p> <p> 课程2：《数理统计与概率论》 </p> <p> 课程3：《代码学习线性代数》 </p> <p> 课程4：《数据处理的最优化》 </p> <p> 课程5：《马尔可夫随机过程》 </p> <p> <br> </p> <p> 哪些人适合学习这门课程？ </p> <p> 1）大学生，平时只学习了数学理论，并未接触如何应用数学解决编程问题； </p> <p> 2）对算法、数据结构掌握程度薄弱的人，数学可以让你更好的理解算法、数据结构原理及应用； </p> <p> 3）看不懂大牛代码设计思想的人，因为所有的程序设计底层逻辑都是数学； </p> <p> 4）想学习新技术，如：人工智能、机器学习、深度学习等，这门课程是你的必修课程； </p> <p> 5）想修炼更好的编程内功，在遇到问题时可以灵活的应用数学思维解决问题。 </p> <p> <br> </p> <p> 在这门「专为程序员设计的数学课」系列课中，我们保证你能收获到这些:<br> <br> <span> </span> </p> <p class="ql-long-24357476"> <span class="ql-author-24357476">①价值300元编程课程大礼包</span> </p> <p class="ql-long-24357476"> <span class="ql-author-24357476">②应用数学优化代码的实操方法</span> </p> <p class="ql-long-24357476"> <span class="ql-author-24357476">③数学理论在编程实战中的应用</span> </p> <p class="ql-long-24357476"> <span class="ql-author-24357476">④程序员必学的5大数学知识</span> </p> <p class="ql-long-24357476"> <span class="ql-author-24357476">⑤人工智能领域必修数学课</span> </p> <p> <br> 备注：此课程只讲程序员所需要的数学，即使你数学基础薄弱，也能听懂，只需要初中的数学知识就足矣。<br> <br> 如何听课？ </p> <p> 1、登录CSDN学院 APP 在我的课程中进行学习； </p> <p> 2、登录CSDN学院官网。 </p> <p> <br> </p> <p> 购课后如何领取免费赠送的编程大礼包和加入答疑群？ </p> <p> 购课后，添加助教微信：<span> csdn590</span>，按提示领取编程大礼包，或观看付费视频的第一节内容扫码进群答疑交流！ </p> <p> <img src="https://img-bss.csdn.net/201912251155398753.jpg" alt=""> </p>