load data infile '/data/import/delta_180_result_op_rule.csv'

into table result_op_rule

character set utf8mb4

fields terminated by ',' optionally enclosed by '"'

lines terminated by '\r\n'

(point_value_prep_id,op_state_group,op_state,op_rule,@var_status)

set status = substring(@var_status, 6, 1);

system-admin@vm-mnt-cs-test:/var/lib/mysql$ my_print_defaults --mysqld

--socket=/run/mysqld/mysqld.sock

--innodb_buffer_pool_size=5G

--user=mysql

--pid-file=/run/mysqld/mysqld.pid

--basedir=/usr

--datadir=/var/lib/mysql

--tmpdir=/tmp

--lc-messages-dir=/usr/share/mysql

--lc-messages=en_US

--skip-external-locking

--bind-address=0.0.0.0

--log_error=/var/log/mysql/error.log

--expire_logs_days=10

--character-set-server=utf8mb4

--collation-server=utf8mb4_general_ci

--plugin-load-add=ha_columnstore.so

--plugin-maturity=beta