细查 发表于 2025-3-25 05:29:48
http://reply.papertrans.cn/20/1916/191561/191561_21.pngostensible 发表于 2025-3-25 10:49:03
Inserting Records,The SQL . statement in SQLite has some interesting features, such as being able to replace an existing record, just like the . statement in Oracle’s PL/SQL. The expression parameter can either be a literal or the return value from a function. We will explore these interesting features together.流逝 发表于 2025-3-25 13:02:32
http://reply.papertrans.cn/20/1916/191561/191561_23.png调色板 发表于 2025-3-25 17:14:12
http://reply.papertrans.cn/20/1916/191561/191561_24.png轻弹 发表于 2025-3-25 20:52:14
Deleting Records,In this chapter, we will discuss the . function in SQLite. In contrast to the other CRUD functions in SQLite, the . function API is the same as in other platforms and implements the basic SQL API, except for the . clause, which allows a developer to set a limit on the number of rows to delete.弄皱 发表于 2025-3-26 01:59:08
Searching for Records in SQLite,This chapter doesn’t show any new SQLite APIs. Rather, it focuses on how you can use the SQLite APIs to create an iOS iPhone app for searching for records in a SQLite database.commensurate 发表于 2025-3-26 07:44:10
Working with Multiple Databases,SQLite has a great feature for managing large volumes of data: multi-database apps. In this chapter, you‘ll see that by creating and attaching multiple databases to the same connection you can improve disk I/O performance and reliability.Wernickes-area 发表于 2025-3-26 10:20:11
http://reply.papertrans.cn/20/1916/191561/191561_28.png真繁荣 发表于 2025-3-26 15:20:40
Analyzing SQLite Databases,This last chapter will focus on the different tools the SQLite platform provides to help you analyze your app‘s databases. Except for the . statement, which can be executed with the . command, the other tools are external software programs. Specifically, in this chapter we will discuss and explore, through examples, the following technologiesbabble 发表于 2025-3-26 17:12:20
http://reply.papertrans.cn/20/1916/191561/191561_30.png