MySQL Tutorials - index of FREE Tutorials for MySQL

(5)Backup Guide	(22)Basics
(3)Exporting	(16)Functions
(38)General Development	(23)General Guides
(13)Miscellaneous	(3)Tweaking

	Send Email Using PHPMailer and CodeIgniter From Website Making Techniques and PHP Development (MySQL General Development)
Send Email Using PHPMailer and Codeigniter provides you simple ways to send email in Codeigniter using PHPMailer as Library

	Visual SQL JOINS From MxTutorial (MySQL Functions)
Visual SQL JOINS, Left join, right join, INNER join, FULL OUTER JOIN

	How to easily install a local MySQL/PHP server From ...site title missing... (MySQL Miscellaneous)
An easy way to develop PHP and MySQL apps locally. How to set up a local apache server with a couple of clicks.

	MySQL Database for Beginners From Udemy (MySQL Basics)
Go from Beginner to Pro in MySQL Databases with Bucky Roberts.

	MySQL group_concat() From ...site title missing... (MySQL Basics)
MySQL GROUP_CONCAT() function returns a string with concatenated non-NULL value from a group.

	MySQL bit_count() function From ...site title missing... (MySQL Functions)
MySQL BIT_COUNT() returns the number of bits set in the argument.

	MySql - current_date From ...site title missing... (MySQL Basics)
In MySQL the CURRENT_DATE returns the current date in ‘YYYY-MM-DD’ format or YYYYMMDD format depending on whether numeric or string is used in the function. CURDATE() and CURRENT_DATE() are the synonym of CURRENT_DATE.

	MySql Data Types From ...site title missing... (MySQL Basics)
A data type specifies a particular type of data, such as integer, floating-point, Boolean etc. A data type also specifies the possible values for that type, the operations that can be performed on that type and the way the values of that type are stored.

	MySQL substring() function From ...site title missing... (MySQL Basics)
MySQL SUBSTRING() returns a specified number of characters from a particular position of a given string.

	MySql count() function From ...site title missing... (MySQL Functions)
MySQL COUNT() function returns a count of number of non-NULL values of a given expression.If it does not find any matching row, it returns 0.

	MySQL date() function From ...site title missing... (MySQL Functions)
MySQL DATE() takes the date part out from a datetime expression.

	MySQL Function & Operators From ...site title missing... (MySQL Functions)
Types of MySQL functions and operators. ecample : Between and COALESCE(),NULL Safe equal to operator (<=>) Equal operator(=) Greater than or equal operator(>=) Greater than operator(>),GREATEST(), IN(),INTERVAL()

	MySQL left join From ...site title missing... (MySQL Miscellaneous)
In this page we have discussed an advanced usage of MySQL LEFT JOIN.

	MySql show database, create database From ...site title missing... (MySQL Basics)
SHOW statement displays a list of currently existing databases on the server.

	MySQL left join From ...site title missing... (MySQL Basics)
In this page we have discussed an advanced usage of MySQL LEFT JOIN.

	SQL where clause From ...site title missing... (MySQL Basics)
The SQL WHERE clause with SELECT statement can retrieve records form a table against some given conditions.

	Sql avg() function From ...site title missing... (MySQL Functions)
The SQL AVG function calculates the average value of a column of numeric type. It returns the average of all non NULL values

	MySQL Tutorial From ...site title missing... (MySQL Functions)
MySQL tutorial of w3resource is a comprhensive tutorial to learn MySQL. We have hundreds of examples covered, often with PHP code. This helps you to learn how to create PHP-MySQL based web applications.

	Quickly Setup a PHP Work Environment with XAMPP From photoshoptalent.com (MySQL Basics)
If you want to get started with programming in PHP, you’re probably wondering what software you need to setup your workspace locally.

	Avoid executing MySQL queries within loops From Bits of PHP (MySQL Tweaking)
Reduce MySQL queries by reorganising your code using a different approach to improve efficiency and make pages load faster.

	How to Assign Column Aliases in SQL Server From SQL Atoms (MySQL General Development)
SQL Server, Functions, COUNT, Distinct, Column Aliases, Aliases, Table Expressions

	How to Create a Table in a Database in SQL Server 2008 R2 From SQL Atoms (MySQL Basics)
This tutorial will show how to create a table in a database in SQL Server 2008 R2 edition. Creating a table in the proper database keeps the data more organized than creating a table outside of a database.

	How to Insert Values into a Table Within a Database in SQL Serve From SQL Atoms (MySQL General Development)
This tutorial will show how to insert values into a table created in a database. Using the INSERT INTO and VALUES statements allows for data to be inserted into a table.

	How to Calculate the Average of a Numerical Column SQL Server From SQL Atoms (MySQL Basics)
This tutorial will show how to calculate the average of a numerical column in SQL Server. Using the AVG function, we are able to calculate the average of a numerical value and output the results in a column alias.

	How to Round a Numeric Column to a Specified Decimal Count in SQ From SQL Atoms (MySQL General Guides)
This tutorial will show how to round a numerical column to a specified number of decimals. With the use of the ROUND function, a numerical column is able to be rounded easily.