MySQL Tutorials
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..
Optimize MySQL tables simple
Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db.
Speed in MySQL is all about how fast the...
MySQL DROP DATABASE Recovery
Is it possible to recover data destroyed by unintentionaly confirmed DROP DATABASE command? This tutorial answers this question and offers step-by-step procedure how to do it, if possible.
Optimizing MySQL: Performance Tuning Script
Performance Tuning Primer Script is the shell script which gets performance related information from MySQL engine and produce some recommendations for tuning of MySQL server variables. Its easy to use and offers valuable output for MySQL performance optimization.
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!
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.
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.
Optimizing MySQL: Configuration Directives
This tutorial is the first part of MySQL optimization mini series and guides you thru the configuration directives which have direct influence on MySQL performance.
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...
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.
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.
