ablog

不器用で落着きのない技術者のメモ

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

Linux

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');

参考