执行语句如下:
SELECT * FROM OPENROWSET(
'MSDASQL',
'DRIVER={MySQL ODBC 5.1 Driver};
SERVER=127.0.0.1;
PORT=3306;DATABASE=test;
USER=root;PASSWORD=123456;
STMT=set names gb2312;
OPTION=6049',
'select * from t_user'
)
go
执行语句如下:
SELECT * FROM OPENROWSET(
'MSDASQL',
'DRIVER={MySQL ODBC 5.1 Driver};
SERVER=127.0.0.1;
PORT=3306;DATABASE=test;
USER=root;PASSWORD=123456;
STMT=set names gb2312;
OPTION=6049',
'select * from t_user'
)
go
转载于:https://www.cnblogs.com/wzg0319/archive/2012/07/28/2613314.html