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?
With OSCON taking place in Oregon from 7/20/2014 – 7/24/2014, the Open Source community will come together to discuss everything new in the Open Source world. From OSS to Java, Python to PHP, Cloud Computing to Perl and emerging programming languages to mobile platforms, the Open Source community has a lot to chat about.
This said, I wanted to take the time to discuss why the Open Source initiative matters by highlighting a few key elements of the protocol which help to make it so powerful.