Home > Topics > Data > MySQL

MySQL

Articles

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 B. Morris

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.

Stephen B. Morris

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.

See More MySQL Articles

Blogs

John  Traenkenschuh

As 2015 winds down to a close, I reflect on what 2015 brought IT.

John  Traenkenschuh

New Mac OS X Means New Tricks...

John  Traenkenschuh

Wow, who abducted our Windows 10 assumptions and left this smooth running and easy-to-use Operating System in their place?

John  Traenkenschuh

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.

See More MySQL Blogs