当前位置: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查看表、字段说明

  1. <span style="color: #000000;">#MySQL查看表、字段说明
  2. mysql</span><span style="color: #808080;">></span> <span style="color: #0000ff;">SELECT</span><span style="color: #000000;"> TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_KEY,COLUMN_COMMENT
  3. </span><span style="color: #0000ff;">FROM</span><span style="color: #000000;">(
  4. </span><span style="color: #0000ff;">select</span> TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,COLUMN_TYPE,IS_NULLABLE,COLUMN_KEY,COLUMN_COMMENT <span style="color: #0000ff;">from</span> information_schema.columns <span style="color: #0000ff;">where</span> TABLE_SCHEMA<span style="color: #808080;">=</span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">complaintdb</span><span style="color: #ff0000;">‘</span>
  5. <span style="color: #0000ff;">UNION</span> <span style="color: #808080;">ALL</span>
  6. <span style="color: #0000ff;">SELECT</span> TABLE_NAME,<span style="color: #ff0000;">‘‘</span>,<span style="color: #ff0000;">‘‘</span>,<span style="color: #ff0000;">‘‘</span>,<span style="color: #ff0000;">‘‘</span>,<span style="color: #ff0000;">‘‘</span>,TABLE_COMMENT <span style="color: #0000ff;">FROM</span> information_schema.tables <span style="color: #0000ff;">where</span> TABLE_SCHEMA<span style="color: #808080;">=</span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">complaintdb</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">
  7. ) a
  8. </span><span style="color: #0000ff;">ORDER</span> <span style="color: #0000ff;">BY</span> TABLE_NAME,(ORDINAL_POSITION<span style="color: #808080;">+</span><span style="color: #800000; font-weight: bold;">0</span>);

Win7下SQLServer访问虚拟机上的MySQL

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

人气教程排行