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

	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 - 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 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.

	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.

	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 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.

	relational databases From CodeCall Programming Forum (MySQL Basics)
this term is used for achieving database efficiency. for a good explanation of what/why click here. this tutorial will show you some common types of this. i will use one example and keep improving it starting from the beginning. the first thing i will do is give you a table structure, then we will improve it using the 2 most common techniques: "1 to 1", and "1 to many".

	sql date functions From CodeCall Programming Forum (MySQL Basics)
one thing you can do with dates is use the unix_timestamp function and the between clause to determine if a date lies between two dates. however, there is a lot more that you can do.

	sql decision structures From CodeCall Programming Forum (MySQL Basics)
if you have programmed before, then these will be familiar. the two control structures available are: case and if.

	sql insert queries From CodeCall Programming Forum (MySQL Basics)
we use sql insert queries to add data into tables. there are two forms of this command. one where we specify the columns we want to insert into and the other where we don't specify what columns to insert into.

	sql: like and not like From CodeCall Programming Forum (MySQL Basics)
using regular expressions allows you to select data that matches a certain format (or perhaps data that does not match a format). for this we use the like and not like clauses.

	mysql tuner optimization From CodeCall Programming Forum (MySQL Basics)
hey guys, if you are having mysql issues on a linux box, try using this, its called mysql tuner. its a neat little tool that tells you why your mysql configuration sucks, and it tells you how to fix it. idiot proof.

	Generate and consume services through the WCF SQL Server Adapter From ...site title missing... (MySQL Basics)
learn about WCF SQL Adapter, how to go about executing composite transactions, polling for data, and using SQL Server Query notifications.

	using set theory to understand sql joins From CodeCall Programming Forum (MySQL Basics)
one of the areas of sql that causes some people issues is understanding how joins work in queries. to help make this clear, i'm going to start with the underlying concept of all of sql: set theory.

	Create MySQL Databse with cPanel and phpMyAdmin From ...site title missing... (MySQL Basics)
This tutorial will show how to create and populate a basic database using cPanel and phpMyAdmin.

	setting up php/mysql on server 2003 From CodeCall Programming Forum (MySQL Basics)
since this can be a pain in the a^&, and jordan wanted a tutorial, i thought i would post this here (and not to mention that i can use it for future reference).

	shell: mysql database backup From CodeCall Programming Forum (MySQL Basics)
i've modified a shell script that was found at http://bash.cyberciti.biz/backup/mysql-backup.bash.php