Script Home
  • Some useful SQLite command summary

    +Read more
    Author:zyq / Release:2015-9-13 / category:SQLite / crowd0 views time+ / Comments Off on Some useful SQLite command summary /
    display table structure: code is as follows: Sqlite> .schema [table] Get all the tables and views: code is as follows: Sqlite >. Tables To obtain a list of the specified table index: code is as follows: Sqlite >The indices [table] Export database to SQL file: code is a...
    commandSQLite
  • SQLite tutorial: C programming example code

    +Read more
    Author:zyq / Release:2015-9-13 / category:SQLite / crowd0 views time+ / Comments Off on SQLite tutorial: C programming example code /
    3, the highly effective bulk data insert:       Before giving steps to briefly explain the concept of bulk inserts, in order to help you read the following sample code. In fact, the bulk insert is not a new concept, in other relational database C interface API provides a certain...
    C language programmingSQLitetutorials
  • SQLite tutorial: memory database and the temporary database

    +Read more
    Author:zyq / Release:2015-9-13 / category:SQLite / crowd0 views time+ / Comments Off on SQLite tutorial: memory database and the temporary database /
    a, memory database:       In SQLite databases are usually stored in the disk file. In some cases, however, we can let the database always reside in memory. One of the most common way is in the call sqlite3_open (), database filename parameter passing ": memory:", such as:  ...
    memory databaseSQLitetutorials
  • SQLite tutorial: online backup

    +Read more
    Author:zyq / Release:2015-9-13 / category:SQLite / crowd0 views time+ / Comments Off on SQLite tutorial: online backup /
    a, commonly used backup:       The following method is relatively simple and commonly used SQLite database backup, as shown in the following steps:       1). Use the SQLite API or Shell tool in the source database file upon Shared lock.       Cp (2)...
    online backupSQLitetutorials
  • SQLite tutorial: command line tools is introduced

    +Read more
    Author:zyq / Release:2015-9-13 / category:SQLite / crowd0 views time+ / Comments Off on SQLite tutorial: command line tools is introduced /
    to do a good job, must first sharpen his device. Learn the SQLite command line tool, for we learn SQLite itself is very, very helpful. The most basic one is that it let us learn the SQLite is more relaxed and pleasant. Get to the point, in the SQLite's official download site, command line tool p...
    command line toolsSQLitetutorials
  • SQLite tutorial: expression of explanation

    +Read more
    Author:zyq / Release:2015-9-13 / category:SQLite / crowd0 views time+ / Comments Off on SQLite tutorial: expression of explanation /
    a, commonly used expression:       Like most relational databases, SQLite can provide the expression of good support in the SQL standard, its function is also consistent with the SQL standard, such as: code is as follows:       | |       * &nbs...
    and expressionSQLitetutorials

0Wide search 1Web Design 2Script 3Network Programming 4Database 5Operating system 6Network Security