SQL is the means by which you tell the server how to perform data management operations, and fluency with it is necessary for effective communication. This chapter covers how to use SQL to manage data, including changing the SQL mode to affect server behavior, referring to elements of databases, using multiple character sets, creating and destroying databases, tables, and indexes, obtaining information about databases and their contents, retrieving data using joins, subqueries, and unions, using multiple-table deletes and updates, performing transactions that enable statements to be grouped or canceled, setting up foreign key relationships, and using the FULLTEXT search engine.
This chapter presents the most important problems you’ll have to solve when working with arrays—and, of course, solutions for these problems.
Stephen Morris provides simple, end-to-end working code illustrating how to modify JPA collection code. Also, the area of MySQL stored procedures is looked at, using some simple examples in this the concluding part of a two-part series.
Having difficulty getting your JPA collection code up and running? Stephen Morris demonstrates an end-to-end, working example of a JPA collection in this first part of a two-part series.
As 2015 winds down to a close, I reflect on what 2015 brought IT.
New Mac OS X Means New Tricks...
Wow, who abducted our Windows 10 assumptions and left this smooth running and easy-to-use Operating System in their place?
Is your information ready for the next 20 years? Traenk gives more information on what you must understand when creating a Data Migration Strategy, something all organizations, businesses, and people must create.