我通过pyodbc连接sql服务器,我想在不同的变量中实现column_name和data_type以供进一步使用
运行结果后,我得到了元组的list
[('USMD_Table', 'bigint'),
('Internal ID', 'float'),
('Summation', 'nvarchar'),
('Date', 'datetime'),
('Period', 'nvarchar'),
('Invoice / Credit / Check ', 'nvarchar'),
('Inv# / Credit Memo # / Check #', 'nvarchar'),
('Name', 'nvarchar'),
('Account', 'nvarchar'),
('Vendor Item #', 'nvarchar'),
('Memo', 'nvarchar'),
('Amount', 'float'),
('Department', 'nvarchar'),
('Location', 'nvarchar'),
('Company (no hierarchy)', 'nvarchar'),
('FileId', 'int')]
我通过pyodbc安装了sql服务器
cursor.execute('''
select COLUMN_NAME ,DATA_TYPE From
INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 'ABCD_A_P'
''')
results = cursor.fetchall()
for val in results:
COL_NAME = val[0]
D_TYPE = val[1]
我只收到COL_NAME和D_TYPE中的一个值
我想在一个变量中获取所有列名,在一个变量中获取所有data_type
分析解答
我想你想说你得到一个"list of tuples"。您总是在for循环中覆盖COL_NAME
和D_TYPE
。你可以得到这样的所有值:
COL_NAMES = []
D_TYPES = []
for val in results:
COL_NAMES.append(val[0])
D_TYPES.append(val[1])