https://wiki.riguz.com/index.php?action=history&feed=atom&title=MySQL%3A%E5%AF%BC%E5%87%BA%E6%95%B0%E6%8D%AE%E5%AD%97%E5%85%B8 2026-06-03T01:07:39Z 本wiki上该页面的版本历史 MediaWiki 1.42.3 https://wiki.riguz.com/index.php?title=MySQL:%E5%AF%BC%E5%87%BA%E6%95%B0%E6%8D%AE%E5%AD%97%E5%85%B8&diff=1808&oldid=prev 2016-11-08T09:12:37Z

<p>以“&lt;source lang=&quot;sql&quot;&gt; select t.table_schema as db_name, t.table_name, (case when t.table_type = &#039;BASE TABLE&#039; then &#039;table&#039; when t.table_type = &#039;VIEW&#039; then &#039;...”为内容创建页面</p> <p><b>新页面</b></p><div>&lt;source lang=&quot;sql&quot;&gt;<br /> select t.table_schema as db_name,<br /> t.table_name,<br /> (case when t.table_type = &#039;BASE TABLE&#039; then &#039;table&#039;<br /> when t.table_type = &#039;VIEW&#039; then &#039;view&#039;<br /> else t.table_type<br /> end) as table_type,<br /> c.column_name,<br /> c.column_type,<br /> c.column_default,<br /> c.column_key,<br /> c.is_nullable,<br /> c.extra,<br /> c.column_comment<br /> from information_schema.tables as t<br /> inner join information_schema.columns as c<br /> on t.table_name = c.table_name<br /> and t.table_schema = c.table_schema<br /> where t.table_type in(&#039;base table&#039;, &#039;view&#039;)<br /> and t.table_schema like &#039;%&#039;<br /> and t.TABLE_SCHEMA = &#039;xx_db&#039;<br /> order by t.table_schema, t.table_name, c.ordinal_position<br /> <br /> &lt;/source&gt;<br /> <br /> [[Category:Database]]</div>

imported>Soleverlee