python-3.x - 如何使用python3从sqlite3数据库中的表中获取列名？

Question

我已经阅读了一些关于此的答案。但他们都给我同样的错误。

以下是我阅读的解决方案:

1. Link 1

2. Link 2

   import sqlite3 as sql
   
   #connect to database
   connection = sql.connect("database.db")
   
   #make a cursor which will move in the database
   cursor = connection.cursor()
   
   #execute the different command
   def execute(cursor, command):
       return cursor.execute(command)
   
   #print the result
   def print_result(result):
       for var in result:
           print(var)
   # select columns' name from table
   
   command = """select distinct emplyee from emplyee.information_schema.columns"""
   
   result = execute(cursor, command)
   print_result(result)
   

---

表名是emplyee。

错误是:追溯(最近一次通话最后一次):

文件“database.py”，第 47 行，在

result = execute(cursor, command)

执行文件“database.py”，第 11 行

return cursor.execute(command)

sqlite3.OperationalError: near ".": 语法错误

Answer 1

SQLite 不支持 information_schema，所以你需要这样做:

def table_columns(db, table_name)
    curs = db.cursor()
    sql = "select * from %s where 1=0;" % table_name
    curs.execute(sql)
    return [d[0] for d in curs.description]