Querying a Database
Let's take a quick break to discuss how a database can be queried. In this section, we'll cover basic SQL as well as what's involved in single-table and multitable querying. This will not only make the next section easier to understand, but it will help categorize the queries that we'll refer to later.
Querying Data
Clients interact with DBMSs by issuing queries. To query means to inquire, so, it's no surprise that queries is the database term used to refer to the retrieval of data. However, when talking about databases, query also applies to the inserting, updating, and deleting of data as well as to the creation, alteration, and destruction of database objects (such as tables). To issue a query to a database means to express ...
Get Building Scalable and High-Performance Java™ Web Applications Using J2EE™ Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
