sqlite判断表字段是否存在
需求:
判断是否存在该字段 如果存在就不更新 如果存在更新表字段
ALTER TABLE 表 add column 新列.....
参考sqlite更新表
create table if not exists BillPay_waimai (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"order_num" NVARCHAR(50),
"outer_order_id" NVARCHAR(50),
"outer_support_id" int(5),
"order_seq" INTEGER,
"start_deliverytime" NVARCHAR(50),
"end_deliverytime" NVARCHAR(50),
"is_print" int(5),
"order_status" int(5),
"total_pay" NVARCHAR(50),
"json_result" TEXT,
"Creation_time" datetime);