Contents

ALTER TABLE `users` ADD `combined_name` VARCHAR(255)  NULL DEFAULT NULL  AFTER `last_name`;

UPDATE `users` SET `combined_name` = (
  select CONCAT(first_name, " ", last_name)
);

CREATE INDEX combined_name ON users (combined_name);

Version data entries

26 entries across 26 versions & 1 rubygems

Version	Path
forklift_etl-1.2.2	example/transformations/combined_name.sql
forklift_etl-1.2.1	example/transformations/combined_name.sql
forklift_etl-1.2.0	example/transformations/combined_name.sql
forklift_etl-1.1.12	example/transformations/combined_name.sql
forklift_etl-1.1.11	example/transformations/combined_name.sql
forklift_etl-1.1.10	example/transformations/combined_name.sql
forklift_etl-1.1.9	example/transformations/combined_name.sql
forklift_etl-1.1.8	example/transformations/combined_name.sql
forklift_etl-1.1.7	example/transformations/combined_name.sql
forklift_etl-1.1.6	example/transformations/combined_name.sql
forklift_etl-1.1.5	example/transformations/combined_name.sql
forklift_etl-1.1.4	example/transformations/combined_name.sql
forklift_etl-1.1.3	example/transformations/combined_name.sql
forklift_etl-1.1.2	example/transformations/combined_name.sql
forklift_etl-1.1.0	example/transformations/combined_name.sql
forklift_etl-1.0.19	example/transformations/combined_name.sql
forklift_etl-1.0.18	example/transformations/combined_name.sql
forklift_etl-1.0.17	example/transformations/combined_name.sql
forklift_etl-1.0.16	example/transformations/combined_name.sql
forklift_etl-1.0.15	example/transformations/combined_name.sql