时间:2021-07-01 10:21:17 帮助过:25人阅读
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