Graph Easy
Graph::Easy lets you generate graphs consisting of various shaped nodes connected by edges (with optional labels).
It can read and write graphs in a variety of formats, as well as rend...
业务背景
有时候我们需要所有的表名称,这个要如何获取呢?
解决方案
所有表名称
select table_name from information_schema.tables where table_schema='数据库表名';
根据表名获取列名与列值
select ORDINAL_POSITION as Colorder,Column_Name as ColumnName...
业务背景
mysql 分组后,取每组第一条数据
环境
MySQL:5.7
SQL
select * from (select distinct(a.id) tid, a.* from template_detail a
where a.template_id in (3, 4)
order by a.id desc) tt
...