Win7下SQLServer访问虚拟机上的MySQL

MySQL查看表、字段说明

<span style="color: #000000;">#MySQL查看表、字段说明
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 
</span><span style="color: #0000ff;">FROM</span><span style="color: #000000;">(
</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>
<span style="color: #0000ff;">UNION</span> <span style="color: #808080;">ALL</span>
<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;">
) a
</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