ALTER TABLE knowledge_repository
ADD COLUMN casno
varchar(100) DEFAULT NULL COMMENT ‘CAS号’ AFTER note
;
update knowledge_repository a set a.casno=(select casno from chemicals_list where (productname =a.name or aliasname = a.name
))
ALTER TABLE knowledge_repository
ADD COLUMN casno
varchar(100) DEFAULT NULL COMMENT ‘CAS号’ AFTER note
;
update knowledge_repository a set a.casno=(select casno from chemicals_list where (productname =a.name or aliasname = a.name
))