What SQLite column name can be/cannot be?

sql sqlite keyword
prosseek picture prosseek · Jul 30, 2010 · Viewed 32.5k times · Source

Is there any rule for the SQLite's column name?

  • Can it have characters like '/'?
  • Can it be UTF-8?

Answer

Spooks picture Spooks · Jul 30, 2010

http://www.sqlite.org/lang_keywords.html that has a complete list! enjoy!

Related questions

Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More
Is it possible to insert multiple rows at a time in an SQLite database?

In MySQL you can insert multiple rows like this: INSERT INTO 'tablename' ('column1', 'column2') VALUES ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'); However, I am getting an error when …

Read More