Recently Popular Mysql Tagged Tutorials
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.
Jan 11
Complete advanced login member system - PHP tutorial
This tutorial will show you how to create an advanced member login system with PHP, users can register, change password, email activation is included.
Dec 8
Creating a simple login script with php and mysql
Learn to create a simple login system with php and mysql in 7 simple steps.
Dec 8
cutenews export to mysql - php tutorial
This tutorial will show you how to export your posts from cutenews into a mysql table.
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 28
Efficient MySQL Class
These days you'll have seen a lot of tutorials offering MySQL classes on the web which can return the amount of queries you're using. That's fair enough, but sometimes you can end up using loads of queries on a page and when you repeat them in a loop it can get pretty tedious for your [...]
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.
