sal

你是说“ 如字符串所述 “作为数据类型还是字符串格式? 我想您不需要带引号的字符串,只需要转换值:

SELECT id, if(Subtask='PTO',Subtask,cast(Hour as char)) Hour, Subtask

或

SELECT id, if(Hour=0,Subtask,cast(Hour as char)) Hour, Subtask

因为文件打开成功, city_info 将会是 true 永远。循环保持不变,直到超过 EOF 因此 city_temp 变为空列表。

我认为应该将循环重写为:

for line in city_info:
    city_temp = line.split(",")
    print(headings[0], "of", city_temp[0], "is", city_temp[2], "Celcius")

基于VIC20和C64