当前位置：Gxlcms > 数据库问题 > Win7下SQLServer访问虚拟机上的MySQL

Win7下SQLServer访问虚拟机上的MySQL

时间：2021-07-01 10:21:17 帮助过：25人阅读

SSMS中查询 SELECT * FROM OPENQUERY(DBLINKVM, ‘select @@port,@@version‘) SELECT * FROM OPENQUERY(DBLINKVM, ‘select * from sakila.actor limit 10‘) SELECT * FROM OPENQUERY(DBLINKVM, ‘show create table complaintdb.area_info‘)

MySQL查看表、字段说明

#MySQL查看表、字段说明
mysql> SELECT TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_KEY,COLUMN_COMMENT 
FROM(
select TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,COLUMN_TYPE,IS_NULLABLE,COLUMN_KEY,COLUMN_COMMENT from information_schema.columns where TABLE_SCHEMA=‘complaintdb‘
UNION ALL
SELECT TABLE_NAME,‘‘,‘‘,‘‘,‘‘,‘‘,TABLE_COMMENT FROM information_schema.tables where TABLE_SCHEMA=‘complaintdb‘
) a
ORDER BY TABLE_NAME,(ORDINAL_POSITION+0);

标签：mysq sha form 上下文 provider mit load 连接 info

Win7下SQLServer访问虚拟机上的MySQL

人气教程排行