对数据库中的表进行分组 [英] Grouping the tables in the database

问题描述

我创建了一个数据库，里面有很多表，很难管理所有的表，那么有没有办法将某些表分组到 phpmyadmin 中的一个文件夹中?

I've created a database with lots of tables in it and its difficult to manage them all, so is there any way to group certain tables into one folder in phpmyadmin?

推荐答案

SELECT column_name,aggregate_function(column_name)从表名WHERE column_name 运算符值GROUP BY column_name;

SELECT column_name, aggregate_function(column_name) FROM table_name WHERE column_name operator value GROUP BY column_name;

这篇关于对数据库中的表进行分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！