4dkankan-center-manage/doc/update-laser-title-2.8.2.sql

use 4dkankan_v4;
use fdkk_laser;

ALTER TABLE `4dkankan_v4`.`t_scene_pro`
    ADD COLUMN `laser_title` varchar(255) NULL AFTER `is_obj`;

ALTER TABLE `4dkankan_v4`.`t_scene_plus`
    ADD COLUMN `laser_title` varchar(255) NULL AFTER `rec_status`;


ALTER TABLE fdkk_laser.t_scene CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;

UPDATE 4dkankan_v4.t_scene_plus d
    JOIN (
    SELECT scene_code,title FROM fdkk_laser.t_scene
    ) as g on d.num = g.scene_code
    set d.laser_title = g.title;

ALTER TABLE fdkk_laser.t_scene CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;