计算mysql记录的存储大小
我正在从事一个员工管理项目,其中一个功能是将特定模块转售给其他公司,以便他们也可以使用该系统。所有的管理工作都将交给超级管理员。并且存储空间也将分配给公司。现在,我如何计算特定公司的存储空间。因为有不同的表存储所有公司的数据。那么,如何通过不同表中的MySQL行或记录来计算特定公司或卖家的存储空间呢?
Example:
company Table:
ID, Name
Department Table:
ID, Name company_id
Employee Table:
ID Name, department_ID
I am working on an employee management project in which a feature is to resell specific modules to other companies so that they could also use this system. And all the administration will be handed over to super admin. And the storage spaces will also be allotted to companies. Now, How can i calculate the storage space for a specific company. Because there are different tables in which the all companies data is stored. So, how can i caluclate the storage space for a specific company or seller through the MySQL rows or records from different tables?
Example:
company Table:
ID, Name
Department Table:
ID, Name company_id
Employee Table:
ID Name, department_ID
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论