2019年4月29日 星期一

sqlite: Add TIMESTAMP to my table

--- Create Template Table  --- DROP TABLE MY_BACKUP; CREATE TABLE MY_BACKUP( person_id INTEGER PRIMARY KEY AUTOINCREMENT, my_link TEXT, my_state CHAR(15), my_name TEXT, record_state INT, time_stamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); Insert into MY_BACKUP(my_link, my_state, my_name, record_state)     Select my_link, my_state,...