MySQL

Articles

Using SQL to Manage Data

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.

Continue reading...

By Paul DuboisApr 29, 2013

Working with Arrays in PHP and MySQL

This chapter presents the most important problems you’ll have to solve when working with arrays—and, of course, solutions for these problems.

Continue reading...

By Christian WenzNov 20, 2012

End-to-End JPA Collections with MySQL, Part 2

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.

Continue reading...

By Stephen B. MorrisMay 1, 2012

End-to-End JPA Collections with MySQL, Part 1

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.

Continue reading...

By Stephen B. MorrisApr 30, 2012

See More MySQL Articles