SQLite Forum

.import syntax error on colon character in table name
Login

.import syntax error on colon character in table name

(1) By anonymous on 2020-10-12 17:36:27 [link]

Hello,

SQLite seems to handle the colon character in table names pretty well, as I can create, update and delete table with colon character in it without problem.

But it does not work in the .import command of the command line sqlite.  
**Example:** `.import file.csv track:someidthere`  
**Error:** `Error: near ":someidthere": syntax error`

I tried using quotes, single quotes and backslashes, nothing worked.

Is there some way to make it work or is it a bug in .import ?

(2) By Richard Hipp (drh) on 2020-10-12 18:00:49 in reply to 1 [link]

Please update to [check-in ce97b56d63d6e03b](src:ce97b56d63d6e03b) or later
and then quote the table name in the ".import" command like this:

~~~~
   .import file.csv "track:someidthere"
~~~~

(3) By anonymous on 2020-10-12 18:28:53 in reply to 2

It works perfectly with and without quotes with this modification. Thanks for the quick update.

(4) By anonymous on 2022-05-09 14:35:27 in reply to 2 [link]

i can't understand what is there...

(5) By Warren Young (wyoung) on 2022-05-09 15:50:03 in reply to 4 [link]

You're replying to a year-and-a-half old post. The change has since been released, [in SQLite 3.34.0](https://sqlite.org/changes.html#version_3_34_0). (Item 4.d.)