sed でファイルの先頭行に文字列を挿入する

sed でファイルの先頭行に文字列を挿入したメモ。

• 文字列を挿入する

$ ls ks*|while read LINE; do sed -i '1s/^/CONSISTENCY LOCAL_QUORUM;\n/' ${LINE}; done

• 確認する

$ head ks_insert_000
CONSISTENCY LOCAL_QUORUM;
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (001, '2024-01-10  17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (002, '2024-01-10  17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (003, '2024-01-10  17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (004, '2024-01-10  17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (005, '2024-01-10  17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (006, '2024-01-10  17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (007, '2024-01-10  17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (008, '2024-01-10  17:30:00');
INSERT INTO poc.partition_id_dist_test (partition_id, date_time) VALUES (009, '2024-01-10  17:30:00');