MySQL

Tutorial	Description
MySQL Basic	Foundation: Create, Insert, Update, Delete, and Query.
MySQL Immediate	Create Table, INSERT MUltiple Records, Multiple Selections, LIKE, IN, AND, OR, IS NOT, NULL Operators
MySQL Data Types	MySQL Data Types
MySQL Clone and Create Table	Create Table, Duplicate Table, Insert Records From other table, Insert From File
MySQL LIMIT	LIMIT query records in a range, and it is use to create or generate pagination in your application.
MySQL Aggregate Functions	Aggregate functions include COUNT, SUM, AVG, MAX, and MIN. GROUP and HAVING clause work with the aggregate functions.
MySQL Joins two or many tables	Query single and multiple records, query with single and multiple table. Use INNER JOIN, LEFT OUTER JOIN, and RIGHT OUTER JOIN for multiple table.
MySQL Administrator	Create database, assign user to the database, change user password, change root password. Reset root password when one forgot. Limit user access or query. Bind MySQL Server to a particular IP address.
MySQL Get Database size	Find out where the MySQL database storage location, and database size.
MySQL Check database status and installation location	Locate the MySQL installation file and get MySQL process that currently is running.
MySQL Importing and Exporting Data	Backup table to file, restore backup from file. Remotely backup and restore. Insert from file.
MySQL Backup and Restore	Backup and restore a database or a particular table.
MySQL Column Alias and Sub-query	Set column alias when you query record. How to use subquery within your query or WHERE clause.
MySQL ALTER	Use ALTER to modify table. Change Table name, modify table column or field.
MySQL Stored Procedure foundation for beginner	Stored Procedure Foundation
MySQL Stored Procedure for Select, Insert, Update, and Delete	Write a store procedure to get all records, delete records, counting records, return range values.
MySQL Cursor	Create and use CURSOR
MySQL Triggers	Create, Display, and Delete Triggers. Write Trigger after INSERT, Delete, and Update. write Trigger before INERT, Delete, and Update.
MySQL View	Create VIEW from single table or multiple table, Update and DELETE VIEW.
MySQL Date and Time functions	Table Colum with Date Time. Add and Subtract from date.
MySQL LIKE operator -	Use LIKE operator to find text.
MySQL Regular Expression and Like	Use Regular Expression and Like to find a particular text within a table. Regular Expression is more flexible and diverse than LIKE operator for find text.
MySQL Full-Text Search	Full text-search performs a natural language search for a string against a text collection.
MySQL Logic Operators	AND, OR, and NOT operators
MySQL Encryption and Decryption functions	Encryption and Decryption
MySQL Comparison	List comparison functions.

All Tutorial Lists

• Tutorial Home
• HTML
• HTML5
• JavaScript
• jQuery

• PHP
• Java
• Learning C
• C++

• MySQL
• PostgreSQL

• Linux Basic Security
• References
• Web Hosting Service

Reference

• EMC
• Linux
• Alfresco
• FTP
• DNS

• HTML Reference
• CSS Reference
• PHP Reference
• MySQL Reference
• PostgreSQL Reference