ALTER TABLE my_table ADD COLUMN time;
UPDATE my_table SET time = CURRENT_TIMESTAMP;
conn = sqlite3.connect('mydb')
c = conn.cursor()
c.execute(f"UPDATE so SET SO='{x}' WHERE Shi='{ship_to_party.strip()}'")
c.execute(f''' UPDATE so SET date = (datetime('now', 'localtime')) WHERE Shi='{ship_to_party.strip()}'; ''')
conn.commit()
conn.close()
参考
https://stackoverflow.com/questions/61966855/how-to-add-column-to-database-with-default