• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• mergeColumns.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.change.expectedSql.mariadb.mergeColumns.sql Maven / Gradle / Ivy

CREATE TABLE lbcat.full_name_table (first_name VARCHAR(50) NULL, last_name VARCHAR(50) NULL)
INSERT INTO lbcat.full_name_table (first_name) VALUES ('John')
UPDATE lbcat.full_name_table SET last_name = 'Doe' WHERE first_name='John'
INSERT INTO lbcat.full_name_table (first_name) VALUES ('Jane')
UPDATE lbcat.full_name_table SET last_name = 'Doe' WHERE first_name='Jane'
ALTER TABLE lbcat.full_name_table ADD full_name VARCHAR(255) NULL
UPDATE lbcat.full_name_table SET full_name = CONCAT_WS(' ', first_name, last_name)
ALTER TABLE lbcat.full_name_table DROP COLUMN first_name
ALTER TABLE lbcat.full_name_table DROP COLUMN last_name