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.

---

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.

---

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.

---

Fixing column encoding mess in MySQL
Just had an interesting issue with an encoding mess on a column containing non-ASCII text. The solution was not immediately obvious so I decided it's worth sharing.

---

SQL SELECT Query Statements with GROUP
A collection of 20 FAQs on MySQL SELECT query statements and basic features. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views; sorting and counting query outputs; grouping outputs and applying group functions.

---

MySQL Introductions
This is just a query tutorial. A query, for those of you who really are just starting, is a batch of commands, or a group of commands.

---

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.

---

Getting Information About Databases and Tables
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and tables it supports.

---

Create New Table
This tutorial will show you how to create new table.

---

Using SELECT to retrieve data
This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics - how to retrieve the values inside a column to ordering data, selecting multiple columns and then tables, joining them..

---

Insert and Update in one query
See how to insert and Update in one query.

---

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.

---

Union Selects
How to efficiently select related data from two databases simultaneously using a single MySQL query.

---

MySQL Table Types
MySQL supports several storage engines that act as handlers for different table types. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables:

---

Getting to Grips with mySQL
This tutorial will show you how to create and query a database using SQL and the mySQL command terminal.

---

MySQL SELECT query from PHP script
This tutorial will show you how to use MySQL querys to database in your PHP scripts.

---

MySQL Date Queries
Rather than querying your database and then using PHP or Perl to calculate values based on a certain date range, you can build the date range inquiry directly into the query statement.

---

Backup your mySQL Database
To backup your database, you will need to use phpMyAdmin. Most hosts have this script pre-installed. If you can't find it, contact your host.

---

Optimizing MySQL: Log Slow Queries
This tutorial is the second part of the MySQL Optimization mini series and introduces the Slow Query Log as well as describes its setup and output.

---

Creating a Table
Creating the database is the easy part, but at this point it's empty, as SHOW TABLES tells you:

---

MySQL Update And Delete
The statement UPDATE is used to change the value in a table.

---

Select Record
This tutorial will show you how to get records in your table in database to show on your PHP files. This SQL statement has many options.

---

How to Optimize Rank Data in MySQL
Suppose you need to calculate constantly-changing information based on constantly-updated information in one or more tables. Are you stuck doing everything in multiple expensive queries? By no means. How careful denormalization and query construction can lower your database load and simplify your code.

---

MySQL Statement Syntax
To help you find the syntax you need when you need it, this appendix lists the syntax for the most frequently used MySQL operations.

---

Entering Queries
It's more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. This section describes the basic principles of entering commands, using several queries you can try out to familiarize yourself with how mysql works.

---

SQL In Simple English - Part I
This article explains the basics of SQL as a Q&A session. Most of the questions are the ones that most novices would like to ask. This approach is excellent and readers who are not familiar with the technology. Since this article is totally language neutral, programmers using any language and who want to do database programming will find it useful.

---

Optimizing for Query Speed
Optimzing your queries can help them run more efficiently, which can save a significant amount of time. This article covers index optimization and index usage and discusses general principles that are useful for optimizing queries to run more efficiently.

---

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.

---

What is MySQL?
Read a comprehensive tutorial on MySQL. The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands through which data can be extracted, sorted, updated, deleted and inserted. SQL has the full support of ANSI (American National Standards Institute), which has laid down certain rules for the language.

---

Create Database and Table
Basic steps on how to setup a mysql database. Includes creating a tables, adding tables, and exporting a database.

---

Build Your Own Database Driven Website Using PHP & MySQL: Part 2
This second installment covers an introduction to databases, logging on to MySQL, defining SQL, inserting data in a table, and modifying stored data.

---

What is MySQL?
MySQL is a freely available open source Relational Database Management System [RDBMS], a database engine of sorts that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing, and processing data in a database, and is most noted for its rapid processing, proven reliability, and ease and flexibility of use.

---

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.

---

Introduction to MySQL
Modern day web sites seem to be relying more and more on complex database systems. These systems store all of their critical data, and allow for easy maintenance in some cases. The Structured Query Language (SQL) is a very popular database language, and its standardization makes it quite easy to store, update and access data. One of the most powerful SQL servers out there is called MySQL and surprisingly enough.

---

MySQL DELAY_KEY_WRITE Option
Another performance option in MySQL is the DELAY_KEY_WRITE option. According to the MySQL documentation the option makes index updates faster because they are not flushed to disk until the table is closed.

---

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.

---

Optimizing MySQL: Importance of JOIN Order
This third part of MySQL optimizing tutorial mini series shows an importance of table order during JOIN. The difference between regular JOIN and optimized one is dramatic, so keep reading!

---

Modifying your MySQL databases to be UTF-8 compliant
Most of us have had problems with UTF-8 problems in PHP and MySQL. Here is how to modify your database and table to be UTF-8 compliant. Most of the time we do set the character set to utf8 but forget to set the collation set to utf8.

---