articles-home

Articles

Your Source for In-Depth Articles and Tutorials

Jagannath Magupalli

Jagannath Magupalli

Founder of Additional Sheet

Brand new

The quick tutorial

Explore a wide array of insightful articles covering programming, web design, development, creative design, and so much more.

MySQL Tutorial
default iamge
User
Additional Sheet

ignite your curiosity

MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Features

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Versions

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Data Types

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Variables

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Install MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Connection

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Workbench

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Create User

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Drop User

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Show Users

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Change User Password

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Create Database

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Select Database

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Show Databases

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Drop Database

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Copy Database

default iamge
User
Additional Sheet

ignite your curiosity

MySQL CREATE Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL ALTER Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Show Tables

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Rename Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL TRUNCATE Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Describe Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL DROP Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Temporary Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Copy Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Repair Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Add/Delete Column

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Show Columns

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Rename Column

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Views

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Table Locking

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Account Lock

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Account Unlock

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Queries

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Constraints

default iamge
User
Additional Sheet

ignite your curiosity

MySQL INSERT Record

default iamge
User
Additional Sheet

ignite your curiosity

MySQL UPDATE Record

default iamge
User
Additional Sheet

ignite your curiosity

MySQL DELETE Record

default iamge
User
Additional Sheet

ignite your curiosity

MySQL SELECT Record

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Replace

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Insert On Duplicate Key Update

default iamge
User
Additional Sheet

ignite your curiosity

MySQL INSERT IGNORE

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Insert Into Select

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Create Index

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Drop Index

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Show Indexes

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Unique Index

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Clustered Index

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Clustered vs Non-Clustered Index

default iamge
User
Additional Sheet

ignite your curiosity

MySQL WHERE

default iamge
User
Additional Sheet

ignite your curiosity

MySQL DISTINCT

default iamge
User
Additional Sheet

ignite your curiosity

MySQL FROM

default iamge
User
Additional Sheet

ignite your curiosity

MySQL ORDER BY

default iamge
User
Additional Sheet

ignite your curiosity

MySQL GROUP BY

default iamge
User
Additional Sheet

ignite your curiosity

MySQL HAVING

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Grant Privilege

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Revoke Privilege

default iamge
User
Additional Sheet

ignite your curiosity

MySQL IF()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL IFNULL()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL NULLIF()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL CASE

default iamge
User
Additional Sheet

ignite your curiosity

MySQL IF Statement

default iamge
User
Additional Sheet

ignite your curiosity

MySQL AND

default iamge
User
Additional Sheet

ignite your curiosity

MySQL OR

default iamge
User
Additional Sheet

ignite your curiosity

MySQL AND OR

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Boolean

default iamge
User
Additional Sheet

ignite your curiosity

MySQL LIKE

default iamge
User
Additional Sheet

ignite your curiosity

MySQL IN

default iamge
User
Additional Sheet

ignite your curiosity

MySQL ANY

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Exists

default iamge
User
Additional Sheet

ignite your curiosity

MySQL NOT

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Not Equal

default iamge
User
Additional Sheet

ignite your curiosity

MySQL IS NULL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL IS NOT NULL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL BETWEEN

default iamge
User
Additional Sheet

ignite your curiosity

MySQL JOIN

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Inner Join

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Left Join

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Right Join

default iamge
User
Additional Sheet

ignite your curiosity

MySQL CROSS JOIN

default iamge
User
Additional Sheet

ignite your curiosity

MySQL SELF JOIN

default iamge
User
Additional Sheet

ignite your curiosity

MySQL DELETE JOIN

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Update Join

default iamge
User
Additional Sheet

ignite your curiosity

MySQL EquiJoin

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Natural Join

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Left Join vs Right Join

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Union vs Join

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Union vs Union All

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Unique Key

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Primary Key

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Foreign Key

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Composite Key

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Create Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Show Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL DROP Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Before Insert Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL After Insert Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL BEFORE UPDATE Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL AFTER UPDATE Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL BEFORE DELETE Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL AFTER DELETE Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Aggregate Functions

default iamge
User
Additional Sheet

ignite your curiosity

MySQL count()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL sum()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL avg()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL min()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL max()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL GROUP_CONCAT()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL first()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL last()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Comments

default iamge
User
Additional Sheet

ignite your curiosity

MySQL CHECK CONSTRAINT

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Change Storage Engine

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Export & Import Database

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Import CSV File in Database

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Export Table to CSV

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Subquery

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Derived Table

default iamge
User
Additional Sheet

ignite your curiosity

MySQL UUID

default iamge
User
Additional Sheet

ignite your curiosity

MySQL LEAD And LAG Function

default iamge
User
Additional Sheet

ignite your curiosity

MySQL CTE

default iamge
User
Additional Sheet

ignite your curiosity

MySQL On Delete Cascade

default iamge
User
Additional Sheet

ignite your curiosity

MySQL UPSERT

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Commands Cheat-Sheet

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Transaction

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Partitioning

default iamge
User
Additional Sheet

ignite your curiosity

MySQL ROW_NUMBER()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Cursor

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Limit

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Stored Function

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Signal Resignal

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Number Format Function

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Ranking Functions

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Window Functions

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Union

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Union vs Union All

default iamge
User
Additional Sheet

ignite your curiosity

MySQL VARCHAR

default iamge
User
Additional Sheet

ignite your curiosity

MySQL ENUM

default iamge
User
Additional Sheet

ignite your curiosity

MySQL SET

default iamge
User
Additional Sheet

ignite your curiosity

MySQL DECIMAL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL CAST

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Convert()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL COALESCE()

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Wildcards

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Alias

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Functions

default iamge
User
Additional Sheet

ignite your curiosity

MySQL ROLLUP

default iamge
User
Additional Sheet

ignite your curiosity

MySQL INT

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Today

default iamge
User
Additional Sheet

ignite your curiosity

MySQL ROW COUNT

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Prepared Statement

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Literals(Constants)

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Date & Time

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Procedure

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Minus

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Intersect

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Storage Engines

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Explain

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Sequence

default iamge
User
Additional Sheet

ignite your curiosity

MySQL JSON

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Standard Deviation

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to select nth Highest Record

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Find Duplicate Records

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Delete Duplicate Records

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Select Random Records

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Extract

default iamge
User
Additional Sheet

ignite your curiosity

MySQL ProcessList

default iamge
User
Additional Sheet

ignite your curiosity

MySQL BIT

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Change Column Type

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Reset Auto-Increment

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Interval

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Login with Different User

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to Change Root Password in MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to Clear MySQL Command Line

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Change Table Name In MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to Connect to MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Add Auto Increment to Existing Column in MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to Add Data to MySQL Database

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to Comment in MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Delete all Data from Table MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to Check Database in MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to Delete a Row in MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to Insert Multiple Rows in MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How To Insert Values in MySQL

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to use MySQL Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to use MySQL Before Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL How to use MySQL After Trigger

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Character Set

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Collation

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Regular Expressions

default iamge
User
Additional Sheet

ignite your curiosity

MySQL MySQL RLIKE

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Not Like Operator

default iamge
User
Additional Sheet

ignite your curiosity

MySQL Not regexp Operator

default iamge
User
Additional Sheet

ignite your curiosity

MySQL regexp Operator

default iamge
User
Additional Sheet

ignite your curiosity

MySQL regexp_instr() Function

default iamge
User
Additional Sheet

ignite your curiosity

MySQL regexp_like() Function

default iamge
User
Additional Sheet

ignite your curiosity

MySQL regexp_replace() Function

default iamge
User
Additional Sheet

ignite your curiosity

MySQL regexp_substr() Function