(John L.) Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. For example, a customer may need to log into a retail website to check his purchasing history. In this instance, the website would have stored two types of data i

(Russell J.T. Dyer) For many MySQL developers, database administration is something that they know little about and, as a result, they avoid. To make MySQL administrative tasks easier, MySQL AB has developed a new graphical user interface to the MySQL server. It’s called simply and appropriately, “M

(Paul DuBois) Problem: You want your program to send a query to the MySQL server and retrieve the result. Solution: Some statements only return a status code, others return a result set (a set of rows). Most APIs provide different functions for each type of statement; if so, use the function t

(Robert Westervelt) When former Oracle and PeopleSoft/JD Edwards executive Tony Gaughan joined Computer Associates International Inc. earlier this year to head its product development team, Gaughan signed on to oversee the open sourcing of its Ingres DBMS. Ingres, which was created nearly three d

(Karam Chand) Many organizations are developing applications that provide information to users and employees when they need it—regardless of their locations. These types of applications, called notification applications, offer these organizations many beneficial uses, including the following: —

(Ian Gilfillan) MySQL newbies often have problems with the MySQL access control system. But once you get used to it, I think you will find it flexible and easy to use, so this month we’re going to examine how to get started with MySQL permissioning.

(kenlin) SSH stands for Secure SHell and is typically used as an encrypted version of telnet. In a telnet session, all communications are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Such sessions are also susceptible to session h

Many changes have been made to temporal – DATE, TIME, DATETIME, and TIMESTAMP – functions in MySQL 4.1. This includes support for microseconds and time zones. In this article, a time value is one of either: TIME, DATETIME, or TIMESTAMP. A date value is one of either: DATE, DATETIME, or TIMESTAMP.

(Zak Greant and Georg Richter) Since the mid-90s, ext/mysql has served as the major bridge between PHP and MySQL. Although there have been a few misfeatures and growing pains over the years, in general, ext/mysql has performed its duty quite well, and kept pace with the changes both in PHP and in My

This chapter covers the MySQL architecture, locking and concurrency, and transactions. It also discusses how to select the right engine and looks at each of MySQL’s storage engines in detail. (From the book High Performance MYSQL: Optimization, Backups, Replication and Load Balancing, by Jeremy Zawo