Jump to: navigation, search

MySQL

From w3cyberlearnings
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

Reference

Navigation
Web
SQL
MISC
References