mysql - 枚举从显示表中检索到的结果

Question

我检索当前数据库中的所有表

#+begin_src sql :engine mysql :dbuser org :database grocer
show tables;
#+end_src

#+RESULTS:
| Tables_in_grocer |
|------------------|
| Customers        |
| OrderItems       |
| Orders           |
| Products         |
| Vendors          |

如何将它们枚举为:

#+RESULTS:
| No. | Tables_in_grocer |
|-----+------------------|
|   1 | Customers        |
|   2 | OrderItems       |
|   3 | Orders           |
|   4 | Products         |
|   5 | Vendors          |

Answer 1

试试这个查询:

  select @a:=@a+1 No, table_name
    from your_schema.tables
    (SELECT @a:= 0) AS a;