摘要:
CTE(Common Table Expression,公用表表达式) WITH testTable AS ( SELECT * FROM pro_leps_task WHERE task_id = 19 ) SELECT * FROM testTable; 优势 可读性更好:CTE 以 WITH 阅读全文
摘要:
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- -- Table structure for act_evt_log -- DROP TABLE IF EXISTS `act_evt_log`; CREATE TABLE `act_evt_log` 阅读全文