User contributions
24 October 2007
MySQL Data Aggregation Functions
Using the MySQL AVG() Function
+2
MySQL Data Aggregation Functions
Using the MySQL AVG() Function
+705
MySQL Data Aggregation Functions
The MySQL Aggregate Functions
+2,176
MySQL Data Aggregation Functions
New page: Sometimes when working with the data stored in a MySQL database table, we are interested not in the data itself, but in statistics about that data. For example, we may not be concerned abo...
MySQL Essentials
no edit summary
+39
MySQL Mathematical Functions
Summary
MySQL Mathematical Functions
MySQL Arithmetic Functions
+1,040
MySQL Mathematical Functions
MySQL Arithmetic Functions
MySQL Mathematical Functions
New page: MySQL provides a a number of functions used for performing algebraic, geometric and trigonometric calculations on database data. In this chapter the basics of using this functions will be ...
MySQL Essentials
no edit summary
+23
Manipulating Numbers and Text in MySQL
Manipulating Numbers and Text in MySQL moved to Manipulating Text in MySQL
Manipulating Text in MySQL
Manipulating Numbers and Text in MySQL moved to Manipulating Text in MySQL
mManipulating Text in MySQL
MySQL String Manipulation Functions
+283
Manipulating Text in MySQL
MySQL String Manipulation Functions
+1,172
Manipulating Text in MySQL
MySQL Text Manipulation
+12
Manipulating Text in MySQL
New page: MySQL provides a number of built-in functions that can be used to both manipulate text values, and also to perform mathematical calculations on numerical values. The purpose of this chapte...
23 October 2007
Working with Dates and Times in MySQL
Retrieving Data Based on Date and Time Criteria
+587
Working with Dates and Times in MySQL
Inserting Date and Time Values into Table Columns
+1,868
Working with Dates and Times in MySQL
Date and Time Functions
+587
Working with Dates and Times in MySQL
Inserting Date and Time Values into Table Columns
+891
Working with Dates and Times in MySQL
Creating Date and Time Fields
+27
Working with Dates and Times in MySQL
Date and Time Functions
+776
Working with Dates and Times in MySQL
Date and Time Functions
+44
Working with Dates and Times in MySQL
Date and Time Functions
+126
Working with Dates and Times in MySQL
Date and Time Functions
-92
Working with Dates and Times in MySQL
Date and Time Functions
-4,951
Working with Dates and Times in MySQL
Date and Time Functions
+98
Working with Dates and Times in MySQL
Date and Time Functions
-1,328
Working with Dates and Times in MySQL
New page: In this chapter of MySQL Essentials we are going to look at storing dates and times in a database table and also retrieving and manipulating these values. == Date and Time Formats == ...
MySQL Essentials
no edit summary
+30
22 October 2007
MySQL Essentials
no edit summary
+9
MySQL Essentials
no edit summary
+50
MySQL Calculations and Concatenations
Trimming Whitespace from Text
+54
MySQL Calculations and Concatenations
Trimming Whitespace from Text
+120
MySQL Calculations and Concatenations
Performing Calculations on Retrieved Data
+5,650
MySQL Calculations and Concatenations
Performing Calculations on Retrieved Data
+61
MySQL Calculations and Concatenations
Performing Calculations on Retrieved Data
+778
MySQL Calculations and Concatenations
New page: When is retrieved from a MySQL database it is not always in the form we need it. For example, we may need to display a customer name and address as a single test string, but in reality the...
MySQL Essentials
no edit summary
+44
Joining Tables in MySQL
Equi-Join (aka the Inner Join)
+5,071
Joining Tables in MySQL
How Does a Join Work?
+5,282
19 October 2007
Joining Tables in MySQL
New page: Table joins provide a way of associating data that resides in different tables during data retrieval. Suppose we have a table in our MySQL database called ''product''. This table contains ...
MySQL Essentials
no edit summary
+30
MySQL Regular Expression Searches
Regular Expressions and Whitespace Characters
-2
MySQL Regular Expression Searches
Matching by Text Position
+6
MySQL Regular Expression Searches
Matching by Text Position
+926
MySQL Regular Expression Searches
Matching by Text Position
+274
MySQL Regular Expression Searches
Matching by Text Position
MySQL Regular Expression Searches
Matching by Text Position
+13
MySQL Regular Expression Searches
Matching by Text Position
+299