General Guides MySQL Tutorials

Writing Syslog Messages to MySQL
In this tutorial, I describe how to write syslog messages to a MySQL database.

MySQL create user
In this MySQL create user article I try to summarize how you can add a new user to your MySQL database.

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

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.

Transact-SQL Understanding Stored Procedures MsSQL
SQL Server FAQs - Transact-SQL Understanding Stored Procedures.

Sending Non-ASCII Text to MySQL
This chapter provides tutorial notes on sending non-ASCII text data to MySQL.

Create MySQL Databse with cPanel and phpMyAdmin
This tutorial will show how to create and populate a basic database using cPanel and phpMyAdmin.

Performance Tuning Best Practices for MySQL
This tutorial will shows Performance Tuning Best Practices for MySQL.

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

Writing Syslog Messages to MySQL
Learn how to write syslog messages to a MySQL database.

Installing phpPgAdmin
This article will show you how to install the latest version of phpPgAdmin (currently 2.3) which allows you easier maintenance of your database.

MySQL User Interface
Read how to define the function Interface, Create function syntax , Drop function Syntax. You can add function with the help of UDF (user defined function) interface. These are complied as object files. After that they can be added to and removed from the server dynamically by using create and Drop function statements.

Understanding Various MySQL Executable Files
Learn how to the execute mysql file. MySQL Provide the executable file and uses the MySQL Client interactive file by this command "shell> mysql db_name ".

MySQL Creating account and changing password
This MySQL provide the new creating account or you want to change the password then make new user .This lesson you learn how to create new password.

MySQL Configuration
In this lesson you will read about the configuration of MySQL. The MySQL server configuration normally started during installation process.

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

Using Fulltext searches
How to set up a database and take advantage of fulltext searches.

Working with MySQL: Storage
This tutorial describes how to work with MySQL storage.

Installing MySQL 5
Read this tutorial and learn how to install MySQL.

Introduction
An introduction to using mysql, from creating databases to modifying tables to creating and deleting rows.