What is the use case? The statement you give will set the value of the "column" field of table "table" to the whole contents of file.txt in each and every row that matches <some condition>
SQLite does not have a symbolic link type. You can store the text of a symbolic link, but accessing the contents would still require readfile() or something similar.. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von sofiestoc Gesendet: Donnerstag, 21. November 2019 13:57 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] Symlink to update a database table Hello, Complete newbie here. I have a text file that contains contigs from an assembly. I was wondering if there is a way to symlink the file to table in sqlite by using bash command. I came across the function readfile but I would prefer to create a symbolic link to the pathway instead of reading the contents of the file. #!/bin/bash sqlite3 db "update table set column=readfile('file.txt') where <some condition>" Best regards, Sofia -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
