Home > Topics > Data > MySQL

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
Stephen B. MorrisEnd-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
Stephen B. MorrisEnd-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

Blogs

Brad YaleWhy Open Source Matters: Musings from OSCON

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.

Continue reading...
By Brad YaleCommentsYesterday
Topics: Other Applications,Home & Office Computing,Python,MySQL,PHP,Information Technology,Python,Programming,Open Source,Ruby/Ruby on Rails,Web Services,Graphics & Web Design,Perl,Web Development,Data,Mobile Application Development & Programming,Perl,Android,Ajax & JavaScript,Linux/UNIX/Open Source,PHP,Linux/UNIX/Open Source Operating Systems,HTML5 & Web Standards,Operating Systems, Server
John  TraenkenschuhIt was 20 years ago today: Data Migration Strategy II
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.

Continue reading...
By John TraenkenschuhCommentsDecember 26, 2013
Topics: Human Resources,MySQL,Software Security,Access,General Security and Privacy,SAP,Sales & Marketing,BusinessObjects/Crystal Reports,SQL Server,DB2,Information Management,Network Security,FileMaker,Information Management,Management & Strategy,Finance & Investing,Data,SQL,Global Business,General Business,Security,Data Analytics and Visualization,Personal Development,Business Applications,Oracle,Business & Management

See More MySQL Blogs

We currently do not have any MySQL related podcasts. Please check back later.