Home > database >  To delete the sqlite database
To delete the sqlite database

Time:10-19

A. Db database, use the db Browser for open SQLite software

Table structure as shown in the figure below:

I now run a select * from AlmHisLog002 where IPARNO=53 AND IACK=0 AND ITIME=1584636642, prompt success, but the inside of the database data is still there, ITIME field is a timestamp, after the switch is the 2020-03-20 00:50:42 excuse me, is this ITIME this field in the SQL statement can use, with no translation, if you want to delete a period with the AND ITIME between * AND * also not line, please see below, AND the statement on success, use to regenerate the corresponding index??

CodePudding user response:

That ace to see!!!!!

CodePudding user response:

Ah, the expert help a look
  • Related