Tag: Open Source

Community

MySQL Database Handling In PHP

(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

Community

MySQL Administrator

(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

Community

Temporal Functionality

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.

Community

Storage Engine (Table Types)

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