Querious Docs
Account

Importing

Import databases and table content from CSV, Tab, or SQL. CSV and Tab settings can be adjusted for compatibility with other programs.

Choose FileImport… and select the file. A sheet appears with the available formats at the top; choose the one that matches your file.

Importing and Executing SQL #

  1. Importing an SQL file simply executes its statements as is without any extra work done by Querious. Select and preview the file.
    2. Importing an SQL file
  2. When importing into MySQL you can choose which database is "selected" and Querious will execute USE <database> before running the import. You can also leave it unselected and no USE will be run.
    3. Selected database while importing an SQL file
  3. If an error occurs during the import, there is an option to either have Querious stop and ask what to do, cancel the import, or ignore the error and continue.
    4. Stop on error options when Importing an SQL file
  4. Run the import and off it goes! Querious can import very large SQL files with ease, so don't hold back.

Importing CSV and Tab #

CSV and Tab files vary by the program that created them, so specify the format in detail. A preview at the bottom of the sheet shows whether the settings are right.

CSV import format settings

Click Next to map the file's columns to the destination table's columns by dragging.

CSV import column mapping
  • Drag the columns you want next to the table columns in Columns to Import. You can import any subset.
  • Columns are initially mapped automatically by name.
  • Select multiple columns with Shift or Command, as in Finder, or Command-A to select all.
  • If the file has no column headers, columns are listed by number along with the first characters of the first row's values to help you tell them apart.

Importing into an Existing Table #

  • Choose the database and table in the popups.
  • Map the file's columns to the table's.
  • Blank values in the file are imported as the Default Value, which starts as the table's own default. Change them individually, or set them all to NULL from the action menu below.

Importing into a New Table #

  • Choose the destination database, then New Table in the table popup.
  • Enter the table name, and optionally the engine and collation.
  • Each column in the file becomes a column in the new table. You can add, remove, and rename columns.
  • Set the type and length in Column Definition wherever the default doesn't suit the data.
  • Blank values are imported as the Default Value, adjustable as above.
Importing into a new table