SQLite cannot store data by executing insert statements.

1. Whether the database executing the insert statement is the database you are viewing. SQLite databases are file-type databases. It is easy to operate the database and view the Database Inconsistency. 2. If a transaction is used, no transaction is committed after the insert operation. 3. Check whether to refresh the database when checking the database.
 

 
Obtain the number of tables in the database.
 

 
Select count (*) from sqlite_master where type = 'table'
 

 
Obtain the total number of rows in a table in the database.
 
 
Select count (*) from Table Name
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
How to check the number of tables in the SQLite database [with scores on top] SQL SERVER: Select name from sysobjects where xtype = 'U' to know the total number is simple: select count (*) from sysobjects where xtype = 'U' in Oracle: Select * From user_tables; ==================================================, neither of the above can be used .. ================------ Solution --------------------------------------------------------Select count (*) from sqlite_master where type = 'table'------ Solution --------------------------------------------------------
 
 
 
 
  
  

    SQL code 
   
Select count (*) from sysobjects where xtype = 'U'/* ----------- 15 (the number of affected rows is 1 )*/------ Solution --------------------------------------------------------
 
   

     SQL code 
    
Select namefrom sqlite_masterwhere type = 'table ';