Free Newsletters:
DatabaseDaily  
Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed



follow us on Twitter

Marketplace Partners
Be a Marketplace Partner

internet.commerce
Be a Commerce Partner


















Brocade Shares Slide on Weak Ethernet Sales

Oracle Details Plans for One JVM - Eventually

Georgia University Stung By Data Breach

internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers


Database Journal | DBA Support | SQLCourse | SQLCourse2








Featured Database Articles

MySQL

MySQL CASE Statements in Multi-Aggregated Crosstab Columns 2/23
Inserting additional columns to a crosstab query is less straightforward than adding row data, because SQL naturally groups data by rows. Moreover, the efficacy of the CASE statement within an aggregate function decreases in direct proportion to the complexity of the criteria. Read on to learn more...

MySQL Multi-Aggregated Rows in Crosstab Queries 2/22
MySQL's crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows you how to apply two different functions to the same field in order to create grouping levels in the row axis.

DRBD and MySQL - Heartbeat Setup 2/11
Heartbeat automates all the moving parts and can work as well with the MySQL master-master active/passive solution as well as it can with the MySQL & DRBD solution. It manages the virtual IP address used by the database, directs DRBD to become primary, or relinquish primary duties, mounts the /dev/drbd0 device, and starts/stops MySQL as needed.

Tips for Simplifying Crosstab Query Statements 2/05
Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results.

Harmonizing Character Encoding Between Imported Data and MySQL 1/28
MySQL's Latin-1 default encoding combined with MySQL 4.1.12's (or greater) UTF8 encoding allows the maximum number of characters codes, however incoming data with different character encoding can still present problems. Rob Gravelle shows you how to avoid problems before a lot of work is required to undo the damage.

DRBD and MySQL - Virtualbox Setup 1/04
DRBD is a Linux project that provides a real-time distributed filesystem. Sean Hull demonstrates how to use Sun's virtualbox software to create a pair of VMs, then configure those VMs with DRBD, and finally install and test MySQL running on volumes sitting on DRBD.

MySQL Creator Fights on Against Oracle 12/30
Monty Widenius launches a new campaign to stop the Oracle-Sun merger.

All About the Crosstab Query 12/29
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.

More Efficient and Readable Select Queries with MySQL Subqueries 12/21
Did you know that MySQL has supported subqueries since version 4.1? In fact, it even boasts a few MySQL-specific features! Rob Gravelle shows you how to use subqueries in MySQL to get the most out of your SELECT queries while making your SQL more readable.

DRBD and MySQL - Excellent Low-cost HA Solution 12/10
DRBD is not only an exciting technology, and a great match with MySQL but it provides a more bulletproof, HA solution for MySQL when you want to do seamless failover. But wait! There's more! It requires less maintenance, and avoids many of the headaches of in-built MySQL replication.

Oracle Denies Reports of MySQL Capitulation 12/04
New York Post claims the database giant gave in to EU concerns.

XPath Support for Working with XML Data in MySQL 11/23
During the past few weeks, we've been getting better acquainted with XML support in MySQL. This article finishes the series by talking about how to manipulate XML data using the XPath, which is a language for navigating and querying XML documents.

Data Formatting, Working with XML Data in MySQL 11/19
Today's article continues to explore XML support in MySQL. Specifically, we'll look at a nicer way to format our resultset. We'll also discuss how to retrieve all of the records from the XML document, using a stored procedure.

Bigger and Better MySQL 11/10
Continuing the article we began in "Faster & Stronger MySQL", this article covers adding additional servers, and application changes in our quest to make our database faster, stronger, bigger and better.

Working with XML Data in MySQL 11/04
When first introduced, a script or application process had to parse XML data and convert it into a valid format for the database and underlying system. Later, databases started to support XML so that no conversion was necessary. This article looks at XML support in MySQL.

MySQL Archives







Latest Forum Threads
MySQL Forum
Topic By Replies Updated
Update trigger in mysql sql 0 January 7th, 12:09 AM
Installing MySQL Steve25 1 December 30th, 02:54 AM
mySQL Master Slave kylesbigdog 3 December 30th, 02:24 AM
Need help with query AmyJoe 0 December 10th, 11:37 AM









The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers