MySQL

#!/bin/bash

values=""

i=1;

size=10000;

while [ $i -le $size ]

do

if (( $i%100>0 )); then

values=$values"('col1Val_$i','col2Val'),"

fi

if (( $i%100==0 )); then

values=$values"('col1Val_$i','col2Val')"

mysql -h[host] -P[port] -u[user] -p[passwd] -e "INSERT INTO [database].[table](col1,col2,colN) VALUES $values"

values=""

fi

i=$(($i+1))

done

Clickhouse

#!/bin/bash

values=""

i=1;

size=10000;

while [ $i -le $size ]

do

if (( $i%100>0 )); then

values=$values"('col1Val_$i','col2Val'),"

fi

if (( $i%100==0 )); then

values=$values"('col1Val_$i','col2Val')"

clickhouse-client -h [host] --port 9000 -u [user] --password [password] --database="[database]" --query "INSERT INTO [database].[table]

(col1,col2,colN) VALUES $values"

values=""

fi

i=$(($i+1))

done