Nov 13
jQuery 1.3 with PHP:- Using the Datatables plugin
From time to time, you will want to show data in your website and allow the data to be sorted and searched. In this chapter, we will look at: • How to install and use the DataTables plugin • How to load data pages on request from the server • Searching and ordering the data
Sep 3
SQL Functions - Math Functions
Just like how programming languages have functions built-in to allow you to do common tasks easily. So does SQL. A lot of these functions are mathematical. Some of them are more useful than others.
Jul 27
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.
Jul 27
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. It’s easy to use and offers valuable output for MySQL performance optimization.
Jul 27
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!
Jun 23
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.
Jun 16
Optimizing MySQL: Configuration
In this first part of the MySQL optimization mini series we'll take a look at configuration directives which have direct influence on MySQL performance.
May 19
Import Structure and Data using phpMyAdmin 3.1
In this extract from Marc Delisle's new book, ‘Mastering phpMyAdmin 3.1 for Effective MySQL Management’, users will learn to bring back exported data created for backup and transfer purposes. They will get an overview of the various options available in phpMyAdmin to import data, and different mechanisms involved in importing SQL and CSV files.
Dec 2
Discover how to interact with MySQL via PHP
This is a tutorial that will show you how to get started using PHP to connect to, and perform various queries on a MySQL database. If you are a PHP programmer, but have no experience with MySQL, this is a great tutorial to get you started.
Aug 18
A Gentle Introduction to SQL
This is an interactive set of tutorials for SQL. Very useful if your are just learning SQL, or if you need a quick reference on how to structure a query.
Jul 16
MySQL Cheat Sheet
This is a basic list of MySQL functions used for retrieving, and manipulating data within your database.