SQLite is an embedded database, and its database is a file. Since SQLite itself is written in C and is small in size, it is often integrated into various applications, even in iOS and Android apps.
It implements a self-sufficient, serverless, zero-configuration, transactional SQL database engine. The SQLite engine is not an independent process , Can be statically or dynamically connected according to application requirements. SQLite directly accesses its storage files.
Advantages of SQLite database
p>
1. No installation, configuration and management are required, and the volume is small, much smaller than some large databases.
2. No external dependencies are required.
3. SQLite transactions are ACID compatible, allowing multi-threading Or access by multiple processes.
4. It can run across platforms and supports most standard sql2 query language operations.
Limitations of SQLite
1. Only LEFT OUTER JOIN is realized.
2. DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT are not supported.
3. FOR EACH STATEMENT triggers are not supported.
4. In SQLite, the view is read-only. You cannot use the view Execute DELETE, INSERT, or UPDATE statements on the computer.
5. The only access permission that can be applied is the normal file access permission of the underlying operating system.< /span>
sqlite command
sqlite commands also include CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. From this point of view, it is the same as sql Very similar. http://www.wu0553.com/news/37247.htmlhttp://www.wu0553.com/news/37250.htmlhttp://www.wu0553.com/news/37251.htmlhttp:// www.wu0553.com/news/37253.htmlhttp://www.wu0553.com/news/37254.htmlhttp://www.wu0553.com/news/37256.htmlhttp://www.wu0553.com/news/ 37257.htmlhttp://www.wu0553.com/news/37259.htmlhttp://www.wu0553.com/news/37260.htmlhttp://www.wu0553.com/news/37261.htmlhttp://www. wu0553.com/news/37263.htmlhttp://www.wu0553.com/news/37267.htmlhttp://www.wu0553.com/news/37268.htmlhttp://www.wu0553.com/news/37322. htmlhttp://www.wu0553.com/news/37366.htmlhttp://www.wu0553.com/news/37370.htmlhttp://www.wu0553.com/news/37377.htmlhttp://www.wu0553. com/news/37395.htmlhttp://www.wu0553.com/news/37396.htmlhttp://www.wu0553.com/news/37397.htmlhttp://www.wu0553.com/news/37402.htmlhttp: //www.wu0553.com/news/37403.htmlhttp://www.wu0553.com/news/37404.htmlhttp://www.wu0553.com/news/37405.htmlhttp://www.wu0553.com/ news/37406.htmlhttp://www.wu0553.com/news/37407.htmlhttp://www.wu0553.com/news/3743 0.htmlhttp://www.wu0553.com/news/37431.htmlhttp://www.wu0553.com/news/37432.htmlhttp://www.wu0553.com/news/37433.htmlhttp://www. wu0553.com/news/37436.htmlhttp://www.wu0553.com/news/37441.htmlhttp://www.wu0553.com/news/37448.htmlhttp://www.wu0553.com/news/37454. htmlhttp://www.wu0553.com/news/37455.htmlhttp://www.wu0553.com/news/37465.htmlhttp://www.wu0553.com/news/37466.htmlhttp://www.wu0553. com/news/37467.htmlhttp://www.wu0553.com/news/37468.htmlhttp://www.wu0553.com/news/37469.htmlhttp://www.wu0553.com/news/37470.htmlhttp: //www.wu0553.com/news/37471.htmlhttp://www.wu0553.com/news/37473.htmlhttp://www.wu0553.com/news/37474.htmlhttp://www.wu0553.com/ news/37475.htmlhttp://www.wu0553.com/news/37476.htmlhttp://www.wu0553.com/news/37477.htmlhttp://www.wu0553.com/news/37478.htmlhttp:// www.wu0553.com/news/37480.htmlhttp://www.wu0553.com/news/37481.htmlhttp://www.wu0553.com/news/37482.htmlhttp://www.wu0553.com/news/ 37483.html
WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 940 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC