INSERT INTO `lb-boot`.`desk_file` (`id`, `pid`, `name`, `type`, `file_name`, `file_path`, `file_size`, `file_type`, `order_no`, `create_by`, `create_time`, `update_by`, `update_time`, `tag`) VALUES ('1', '', '最近上传', 2, NULL, NULL, NULL, NULL, NULL, 'all', '2022-05-18 00:00:00', 'admin', '2022-05-18 16:12:31', 'desk');
|
INSERT INTO `lb-boot`.`desk_file` (`id`, `type`, `name`, `create_by`,`create_time` , `tag` )
|
SELECT id , 2, username as `name` ,username as create_by ,'2022-05-20 00:00:00' ,'desk' from sys_user2, username as `name` ,username as create_by ,'desk' from sys_user
|
