mysql怎么把字段的值改为他自己的id值

Question

mysql怎么把字段的值改为他自己的id值
mysql怎么把字段的值改为他自己的id值
mysql怎么把字段的值改为他自己的id值

Answer 1

UPDATE xxl_job_qrtz_trigger_logglue SET job_id = id WHERE id = 4;

"id" "job_id" "glue_type" "glue_source" "glue_remark" "add_time" "update_time"
更改前 "4" "2" "2" "2" "2" "2021-08-03 11:27:11" "2021-08-03 11:27:12"
更改后 "4" "4" "2" "2" "2" "2021-08-03 11:27:11" "2021-08-03 11:27:12"

CREATE TABLE `xxl_job_qrtz_trigger_logglue` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `job_id` INT(11) NOT NULL COMMENT '任务，主键ID',
    `glue_type` VARCHAR(50) NULL DEFAULT NULL COMMENT 'GLUE类型' COLLATE 'utf8_general_ci',
    `glue_source` TEXT(65535) NULL DEFAULT NULL COMMENT 'GLUE源代码' COLLATE 'utf8_general_ci',
    `glue_remark` VARCHAR(128) NOT NULL COMMENT 'GLUE备注' COLLATE 'utf8_general_ci',
    `add_time` TIMESTAMP NULL DEFAULT NULL,
    `update_time` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;