如何提取重复的代码。。。可能是存储函数?

我建议使用视图:

CREATE OR REPLACE VIEW uploads_current AS
  SELECT * FROM `uploads
  WHERE `deleted` <> 1 AND `archived` <> 1;

然后您可以使用其他条件进行查询:

  SELECT * FROM `uploads_current`
  WHERE `uid` = :uid;

以后可以重新定义视图:

CREATE OR REPLACE VIEW uploads_current AS
  SELECT * FROM `uploads
  WHERE `deleted` <> 1 AND `archived` <> 1 AND uploadsuccess = 1;

然后,查询uploads\u current的所有代码都将隐式包含相同的条件,无需更改代码。

了解有关视图的更多信息: https://dev.mysql.com/doc/refman/5.7/en/create-view.html

这是一个常见的问题,我们希望存储所有数据,但99%的情况下,我们会过滤掉某个数据子集。

我通常使用的解决方案是使用中的逻辑创建一个视图,然后对其进行查询。例如:

CREATE VIEW `uploads_view` AS
SELECT * FROM `uploads`
WHERE `deleted` <> 1
AND `archived` <> `;

SELECT * FROM `uploads_view` WHERE `uid` = :uid;

SELECT * FROM `uploads_view` WHERE `folder_id` = :folder_id