tailieunhanh - Android – SQL DatabasesSQL Databases

SQL Databases Using SQL databases in Android. Android (as well as iPhone OS) uses an embedded standalone program called sqlite3 which can be used to: create a database, define SQL tables, indices, queries, views, triggers Insert rows, delete rows, change rows, run queries and administer a SQLite database file. | Database 17. Android - SQL Databases SQL Databases Using SQL databases in Android. Android as well as iPhone OS uses an embedded standalone program called sqlite3 which can be used to create a database define SQL tables indices queries views triggers Insert rows delete rows change rows run queries and administer a SQLite database file. CXI XI 17. Android - SQL Databases SQL Databases Using SQLite 1. SQLite implements most of the SQL-92 standard for SQL. 2. It has partial support for triggers and allows most complex queries exception made for outer joins . 3. SQLITE does not implement referential integrity constraints through the foreign key constraint model. 4. SQLite uses a relaxed data typing model. 5. Instead of assigning a type to an entire column types are assigned to individual values. This is similar to the Variant type in Visual Basic. 6. Therefore it is possible to insert a string into numeric column and so on. Documentation on SQLITE available at http Good GUI tool for SQLITE available at http 3