Get new column value using MySql autoincrement column and keep referential integrity
Get new column value using MySql autoincrement column and keep referential integrity
EXTRACT_LOAD
com.toolsverse.etl.driver.mysql.MySqlDriver
drop_table
dest
com.toolsverse.etl.core.task.common.SqlTask
drop table config_property_test;
create_table
dest
com.toolsverse.etl.core.task.common.SqlTask
create table config_property_test ( CONFIG_PROPERTY_NUM BIGINT not null AUTO_INCREMENT, NAME VARCHAR(255), DESCRIPTION VARCHAR(255), DEFAULT_VALUE VARCHAR(255), CFG_PROP_NUM BIGINT, primary key (CONFIG_PROPERTY_NUM) )
config_property
select config_property.*, config_property_num as config_num, config_property_num as cfg_prop_num from config_property
config_value
select * from config_value
second_config_value
select config_property_num as con_prop_num, value from config_value
config_property_test
config_property
yes
config_value_test
config_value
yes
second_config_value
yes