需求:想在目录表插入记录时,自动设置order_num字段值。
参照:
INSERT INTO `base_directory`(`directory_id`, `parent_id`, `directory_name`, `order_num`)
VALUES (25, 1, '目录名称', (SELECT MAX(b.order_num)+1 as order_num FROM base_directory b));
需求:想在目录表插入记录时,自动设置order_num字段值。
参照:
INSERT INTO `base_directory`(`directory_id`, `parent_id`, `directory_name`, `order_num`)
VALUES (25, 1, '目录名称', (SELECT MAX(b.order_num)+1 as order_num FROM base_directory b));