General Guides 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.

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.

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.

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.

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..

Learnt to create Essbase database and Essbase Application
This tutorial by Joseph Sydney Gomez and Sarma Anantapantula, will give readers a brief introduction about Online Analytical Processing (OLAP) and also teach them to create an application and database.

Xampp & Wordpress
Learn how to use wordpress with a server package called xampp.

SQL Tutorial For Beginners
In this tutorial, you will learn how to: Select data from a database; Filter data using Where clause; Sort data by Order; Use wildcards for smart search; Use aggregate functions; Insert data into a database; Update data in a database; Delete data from a database; Create, update and delete tables.

Tutorial: Advanced SQL
SQL is perhaps, a very easy language, so here we will try to explore its advanced nature...so that you will see that you can do a lot more with SQL. More than just "select", "order by" and so on...

MySQL Database Handling in PHP
Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user.