openspecimen
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
set_pv_ids
Parameters
Name
Type
Mode
data_table
varchar(30)
IN
old_column
varchar(30)
IN
new_column
varchar(30)
IN
attribute
varchar(64)
IN
Definition
begin set @set_ids = concat( 'update ', data_table, ' d', ' inner join catissue_permissible_value pv ' ' on pv.value = d.', old_column, ' and pv.public_id = '', attribute, ''', 'set ', ' d.', new_column, ' = pv.identifier '); prepare set_ids from @set_ids; execute set_ids; deallocate prepare set_ids; end