Web Development > mysql & postgres

View a different subcategory in Web Development:

A Database Journal Guide to MySQL Certification: Part 1, Core Certification

April 12, 2005

Ian Gilfillan provides a reference for studying for the Core certification, including a list of topics covered in the Core exam, as well as resources from the MySQL site and Database Journal that you can use to enhance your studies....

Reference | from databasejournal.com | by theWHIR.com

The HAVING and GROUP BY SQL clauses

February 10, 2005

This month's topic often baffles inexperienced SQL coders. We will look at the GROUP BY clause, and the difference between conditions placed in the WHERE clause, and the HAVING clause...

Reference | from databasejournal.com | by theWHIR.com

Synchronize MySQL Data Using SQLyog Job Agent

February 12, 2004

What's the best and most efficient way to synchronize data between two MySQL databases? Using SQLyog Job Agent!...

Reference | from sitepoint.com | by theWHIR.com

MySQL's Query Cache

November 19, 2003

Usually, you would want to implement some sort of caching on the web server, but sometimes this is not possible, and then it is the query cache you will look to for help....

Reference | from databasejournal.com | by theWHIR.com

MySQL Breaks Into the Data Center

November 04, 2003

MySQL is changing the nature of the database market with a powerful combination of low cost and high performance....

Reference | from computerworld.com | by theWHIR.com

Importing Data into MySQL with Navicat

October 21, 2003

This article discusses a solution to import MS Excel, MS Access, XML data to local or Remote MySQL databases by using a famous MySQL Admin Tool called Navicat....

Reference | from stardeveloper.com | by theWHIR.com

Connecting to a MySQL Database using Connector/J JDBC Driver.

October 01, 2003

This tutorial covers topics including database URLs in JDBC, why and how to specify a JDBC driver name and how to create a connection to a database....

Reference | from stardeveloper.com | by theWHIR.com