(Alexander Barkov and Peter Gulutzan) MySQL version 5.1.5 has functions for searching and changing XML documents. This article has examples.

(Bryan Sylverson) Figure 3-7 introduces you to functions and illustrates how you use them in column specifications. A function performs an operation and returns a value. For now, don’t worry about the details of how the functions shown here work. You’ll learn more about all of these functions in cha

(Laurence Moroney) Once in a while something comes along that is so simple, so straightforward, and so obvious that it’s amazing that nobody did it long ago. Take blogging, for example: People have been putting their thoughts into various media for a long time, certainly long before the Web. Give so

(Keith Brown) By this point you should be very familiar with SQL statements and manipulating data within database TABLEs. In this part of the Using MySQL series we will look at manipulating database tables rather than just the data within. Before beginning, ensure that you have opened your own MySQL

(Andrew Dunstan) Many programming languages support an enumerated type in some form. In C and C++, they are a kind of symbolic mapping to integers, but in other languages (such as Ada), they are more first-class citizens in the type system. Leaving enumerations out of the original Java language defi

(Keith Brown) In the previous MySQL Virtual Workshops we have looked at logging into MySQL, creating tables, adding and selecting data using SQL statements. In this Workshop we will continue to look at other SQL commands, specifically updating and deleting, and revisit the SELECT command to examine

(Carsten Pedersen) The following is the foreword of the MySQL 5.0 Certification Study Guide. It outlines the changes that are being made in the MySQL certification program, and provides the reasons why those changes were made.

(Vance McCarthy) Flashline, author of software asset management solutions, has put together a Patterns Book for helping get Open Source projected started within an enterprise, even very demanding ones

(Bryan Sylverson) To help you learn to code SELECT statements, this chapter starts by presenting its basic syntax. Next, it presents several examples that will give you an idea of what you can do with this statement. Then, the rest of this chapter will teach you the details of coding this statement.

(Keith Brown) A common problem when learning how to the MySQL Command Line Client is getting the syntax exactly right. There are several conventions which are used throughout the MySQL virtual workshops when displaying commands that you will have to type.