摘要:
mybatis 3个结果类 @Data public class SysUserVo implements Serializable { private static final long serialVersionUID = 1L; private Long userId; private Lon 阅读全文
摘要:
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` 阅读全文