1.SQLite database How to query the table table1 20th to 30 records?
- SELECT * FROM table1 limit 19,11 ==> starting from 19, 11 data
2. How can I copy the table structure and data of the Table1 table to table table2?
- CREATE TABLE Table2 as SELECT * FROM table1;
3. How do I get the number of record rows affected by the most recent Execute SQL statement?
- INSERT INTO table1 values (1, ' Bill ');
- Select changes (); ==> returns the number of record rows affected by the INSERT statement
4. Use the LIKE clause and the LIKE function to query the Table1 Name field, respectively?
- Like function: SELECT * FROM table1 where like ('%bill% ', name);
- LIKE clause: SELECT * FROM table1 where name like '%bill% '; \
5. If the current date is 2012-11-01, how does it become 2011-12-01?
- Select Date (' 2012-11-01 ', '-1 years ', ' +1 months ')
How does 6.Android support centralizing open or create SQLite databases?
- Sqliteopenhelper class
- Context.openorcreatedatabase method
- Sqlitedatabase.openorcreatedatabase method
7. Please explain what is the DB4O database?
- DB40 is the database for objects, an embedded open-source object-oriented
- Db4o is an object-based database
- While the other object persistence framework requires a mapping file to associate a relational database with an object
Android Interview Collection record database
