Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Fix My PC Mike
Lv 5
Fix My PC Mike asked in Computers & InternetProgramming & Design · 1 decade ago

how to reference a column in a SQLite database named index?

I'm trying to query a SQLite database using SQLite Browser, but one of the tables has a primary index named index. Since that's a reserved word I get a syntax error. How can I query that column?

2 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    [index]

  • ?
    5 years ago

    The first query must be SELECT table_name from information_schema.tables About the second one. I don't understand what you are trying to obtain.

Still have questions? Get your answers by asking now.