User contributions
29 October 2007
MySQL Users and Security
Deleting a MySQL User
+182
MySQL Users and Security
Creating a New MySQL User
+1,230
28 October 2007
27 October 2007
MySQL Users and Security
Getting Information About Users
+1,036
MySQL Users and Security
New page: In today's information based society nothing is more valuable than information. Today, that information is almost certainly stored in a database of some form or another. Whether it is a co...
MySQL Essentials
no edit summary
+31
An Introduction to MySQL Views
no edit summary
+4,022
26 October 2007
An Introduction to MySQL Views
Creating a View
+62
An Introduction to MySQL Views
New page: MySQL views provide a way to gather data from multiple tables into a single virtual table. If you are familiar with the concept of Joins then you can think of a view as a pre-configured jo...
MySQL Essentials
no edit summary
+37
MySQL Data Aggregation Functions
Using the MySQL COUNT() Function
+1,590
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...