Skip to main content

Functions for Working with Files


Reads a file as string and loads the data into the specified column. The file content is not interpreted.

Also see table function file.


file(path[, default])


  • path — The path of the file relative to user_files_path. Supports wildcards *, **, ?, {abc,def} and {N..M} where N, M are numbers and 'abc', 'def' are strings.
  • default — The value returned if the file does not exist or cannot be accessed. Supported data types: String and NULL.


Inserting data from files a.txt and b.txt into a table as strings:

INSERT INTO table SELECT file('a.txt'), file('b.txt');