MYSQL HELP, MYSQL TUTORIALS, MYSQL PROGRAMMING, LEARN MYSQL TRICKS

Oracle announced the expansion of its Oracle PartnerNetwork Specialized program with the addition of a MySQL Specialization. MySQL holds the distinction of being the word’s most popular open-source database offering, boasting a customer base of over 3,000 independent software vendors, original equipment manufacturers, and value-added resellers. Oracle’s latest creation of the MySQL Specialization reaffirms the company’s commitment to increasing the appeal and presence of the MySQL platform.

Constant Contact, a provider of marketing services to over 450,000 businesses worldwide, recently announced the selection of SkySQL as its go-to choice for MySQL-related support, software, and other services.

In this article I show you how to work with the REVOKE MySQL statement. It can be used for removing the privileges assigned via its counterpart GRANT, in either the global, database or table scope.

In this article, I'll introduce you to what the MySQL GRANT statement is, and how it can be used to assign all sorts of privileges to a given user, based on different scopes and conditions.

SuccessBricks, Inc., a global provider of enterprise and cloud-based software solutions, announced the availability of its ClearDB database-as-a-service as an add-on for Heroku, a widely-used cloud application platform. With the move, Heroku developers around the world can enjoy the luxury of having ClearDB’s noted power, affordability, reliability, and high availability of its MySQL database service at their fingertips.

In this conclusion to a three-part tutorial, you'll see that implementing a customizable ORM using modern development techniques is a fairly straightforward process. We'll use the dependency injection technique, the data mapper pattern and a domain model. This powerful combination allows you to easily manipulate relationships between entities.

India-based TROSYS Technologies recently announced the availability of TroSQL Free 1.10, a MySQL manager and admin tool that comes equipped with a full set of features that can be employed by a wide variety of users, including database administrators, database architects, software and web developers, corporate database research and development departments, testers, as well as institutes of higher learning and students.

If you feel that the features provided by popular ORM packages like Doctrine 2.x or RedBeanPHP are rather like overkill for handling the relationships between the domain objects that comprise your applications, then take a peek at this tutorial. In a step-by-step fashion, you’ll be guided through the development of a simple, extendable ORM, which you’ll be able to tweak to suit your personal requirements and needs.

In this first part of the tutorial, I implement the base functionality of a custom ORM (object relational mapper) using PHP.

Jelastic, a company that specializes in providing Java hosting platform solutions in the cloud, recently released data showing the open source database preferences of approximately 1,000 of its users. The data, while limited in its sample size, shows that MySQL is the open source database king amongst its peers.

MySQL VP of engineering Tomas Ulin used a keynote speech at last week’s OpenWorld Conference in San Francisco to announce the availability of a second development milestone release (DMR) for MySQL 5.6 and MySQL Cluster 7.2. According to Ulin, the releases are a perfect example of Oracle’s dedication to increasing MySQL’s feature set and stability.

Security vendor Imperva recently released its latest Hacker Intelligence Initiative report that details the problems associated with the growing presence of SQL injection attacks. As written in the company’s blog post, “SQL injection is the most pernicious vulnerability in human computer history.”

Idera, a Houston-based Microsoft Gold Partner and provider of management and administration tools for Microsoft SQL Server, PowerShell, and SharePoint, recently announced the release of SQL defrag manager v3.0.

In this MySQL database engine comparison article, we look at the features offered by MyISAM and InnoDB.

In this MySQL database tutorial, you will learn how to perform LEFT and RIGHT joins using a sample database and some hands-on examples.