mysql:添加索引
摘要:ALTER TABLE tb_user_type ADD INDEX user_type_index3 (report_type_id) ALTER TABLE tb_user_type ADD INDEX user_type_index2 (user_id) ALTER TABLE tb_user
阅读全文
mysql: update字段中带select
摘要:update字段中带select UPDATE tb_report_type A INNER JOIN (SELECT LEVEL_CODE FROM tb_report_type WHERE id = 'ED894BE001CE4F47A2916287A491B4E1') BSET A.LEVEL
阅读全文