MySQL Tutorials

Auto increment a value on the fly
By assigning a value to a variable in MySQL and incrementing the variable as part of a select statement, it's possible to have a number auto-incremented on the fly. This number has no other reference to the table other than the order the data is selected. It is also possible to auto increment the variable when running an update statement so a new set of incrementing values could be stored into the table.

Changing Column Size
Changing the size of a column in MySQL is pretty easy. By using alter table and modify you are able to choose a column on a specified table and resize it. Learn how to resize a MySQL column.

Using MySQL Functions for More Efficient Web Applications
There is much debate as to whether or not data calculations should be done in the web app or in the database. There are good arguments on both sides. Depending on what is being calculated, executing calculations in some web programming languages tends to be faster than doing the same thing in the database. However, keeping the calculation in SQL means that the functionality is portable, and often means that less data needs to be retrieved from the database.

How to Change a Column Name
If you have created a database and decide later that one of the column names you chose isn't exactly what you want, you can rename it. You do this using alter table and change. Together they can be used to rename a MySQL column.

Getting Started with MySQL Stored Procedures
In this tutorial, you will write the first simple stored procedure and invoke it from command line of MySQL.

Query to find the second lowest column value in a table
In this ms sql server tutorial you will learn query to find the second lowest column value in a table.

Query to find the second highest column value in a table
In this ms sql server tutorial you will learn query to find the second highest column value in a table.

Speed Up Your Web Site With MySQL Query Caching
One of the best ways to speed up your web application is to enable query caching in your database, which caches commonly used SQL queries in memory for virtually instant access by the next page that makes the same request.

SQL Diagnostic Tools
No matter what they say, I don't think it's true. Database 'experts' say that 80-90% of a database's overall performance comes from the SQL code that's running against it. And I just don't buy it. Instead, I think that most of a database's performance comes from optimal design, and after that SQL code comes next.

Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications
Error handling implementation in Windows database applications is a must for any Application Developer today. The main idea of error handling is to avoid application crashes by finding out the occurred errors and fixing them. Different programming languages have different ways of implementing error handling.

Getting started with DTracing MySQL
DTrace is a dynamic tracing facility built into the Solaris and Open Solaris operating systems and can be used by system administrators and developers alike to observe the runtime behavior of user level programs and of the operating system itself.

Developing Database Applications Using MySQL Connector/C++
This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database.

MySQL 5.4: Up To 90% Faster Response
Sun Microsystems, Inc. today announced MySQL 5.4, a new version of the world's most popular open source database, designed to deliver significant performance and scalability improvements to MySQL applications.

A Quick Look at MySQL 5.4
There are other enhancements in MySQL 5.4 as well such as the introduction of DTrace support for MySQL on the Solaris platform, and a replication heartbeat, which helps ensure that master/slave topologies are up and running. All in all, the 5.4 release focuses quite a lot on transparent performance improvements and extra diagnostic and error handling capabilities, which are things normally always welcomed by developers and DBAs.

Why Move to MySQL from Microsoft SQL Server?
I find MySQL a very worthy alternative to SQL Server, especially in the departmental applications area and Small-Medium Business (SMB) market segment where SQL Server is routinely found. Of course, MySQL excels in the Web, embedded, SaaS, Telco, and Enterprise 2.0 areas as well and has the premier customer rolodex to prove it.

Meet Quan (Query Analyzer)
During my years as an application developer I was most in my element when working on projects that involved building applications from the ground up. Somehow taking user and customer pain points and requirements and turning them into a working solution was much more satisfying than upgrading an existing application, fixing bugs, or tracking down and tuning a slowdown, especially when these tasks involved code I had not created.

Introducing the MySQL Librarian
The MySQL Librarian is a collection of community-generated and cross referenced content related to MySQL. It's a place where the community, collaboratively, builds and maintains MySQL content.

Primary Keys and Foriegn Keys in Databases
As you may already know, databases use tables to organize information. (If you don't have a basic familiarity with database concepts, read What is a Database?) Each table consists of a number of rows, each of which corresponds to a single database record. So, how do databases keep all of these records straight? It's through the use of keys.

Basic sql optimization for MySql
It’s important to know how to write your queries fast. And there are also ways to do your queries faster Inside mysql, called Indexes. They help mysql do the work faster, but you need to tell how: When you start getting large tables you can sometimes end up with slow running queries.

Sub queries
Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You dont need to do that much programming in PHP, just let mysql do the work A new thing in MySql 5 is the possibility to use something called "sql subqueries". It can be a very powerful new tool..