( snq- | 2024. 05. 29., sze – 09:52 )

$ sqlite3
sqlite> .mode csv
sqlite> .separator "\t"
sqlite> CREATE TABLE "servers"("backup", "vm", "hostname");
sqlite> .import lista.txt servers
sqlite> UPDATE servers set backup='1716491210' WHERE hostname='dbs01'; UPDATE servers set backup='1716483542' WHERE hostname='web99';
sqlite> .once lista.txt
sqlite> SELECT * FROM servers;
sqlite> .quit