Java用sqlit拆分小数_如何将SQLite列中的分隔值拆分为多列

拉开一列是为Python非常简单(不确定关于SQLite)。这将您的DB行简化为一个字符串数组，并且应该与SQLite返回类似。

text = [

'Apple',

'Banana, Pear',

'Lemon, Peach, Apricot'

]

for line in text:

cols = [c.strip() for c in line.split(',')]

print(cols)

应该输出每串线阵列：

['Apple']

['Banana', 'Pear']

['Lemon', 'Peach', 'Apricot']

编辑：

这里有一个完整的Python脚本，做你想找什么样的SQLite的：

import sqlite3

conn = sqlite3.connect('test.db')

c = conn.cursor()

c.execute(

'''SELECT *

FROM Fruits

WHERE Fruit_Basket IS NOT NULL'''

)

rows = c.fetchall()

for row in rows:

fruit_basket = row[0]

fruits = [f.strip() for f in fruit_basket.split(',')]

while (len(fruits) < 3):

fruits.append('')

print(fruits)

update = '''UPDATE Fruits

SET Fruit1 = ?, Fruit2 = ?, Fruit3 = ?

WHERE Fruit_Basket = ?'''

c.execute(update, fruits + [fruit_basket,])

conn.commit()

conn.close()