SAS

sas是怎么链接MySQL数据的？

0
2015-10-19 添加评论
分享

没有找到相关结果

    已邀请:
    1

    Imscola 2015-10-19 回答

    需要SAS/ACCESS Interface to MySQL模块
    1.下载安装MySQL. http://www.mysql.com/
    2.修改环境变量path.增加路径C:\Program Files\MySQL\MySQL Server 5.6\lib，路径下面应该包含 libmysql.dll
    3.重启电脑，测试
    1    libname mysqllib mysql user='mysql' password=XXXXX database=sas
    
2    server='192.168.1.150' port=3306;
    
NOTE: Libref MYSQLLIB was successfully assigned as follows:
    
      Engine:        MYSQL
    
      Physical Name: 192.168.1.150
    
3    proc sql;
    
4       connect to mysql as dbcon
    
5           (user=mysql password=XXXXX server='192.168.1.150'
    
6            database=sas port=3306);
    
7    quit;
    
NOTE: PROCEDURE SQL used (Total process time):
    
      real time           0.26 seconds
    
      cpu time            0.01 seconds
    2015-10-19 0
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册