Various MySQL Functions and their Use

Function in MySQL by Topic

Select Queries

• How to Create a MySQL Inner Join Query
• Comparing Data in different Tables Using IN, NOT IN
• How To Use DATE_ADD in a Query
• How To Use Nested Select Query
• Pattern Matching Using Like Statement
• Using Between in Select Query
• Using OR, || & AND, && in Select Query Statements
• Comparing Dates and Selecting Date Differences
• How To Use Left Join Select Queries
• Compound Queries On Multiple Database Tables

• Updating a Single Database Table
• Updating Multiple Tables in the Same Query

Delete Queries

• Delete Single Record in Database Table
• Delete Multiple Records Across Different Database Tables

Alter Table Queries

• Change Database Table Structure Using Alter Statement & Drop Option
• Renaming Table Fields Using Alter & Change Command
• Renaming Table Names Using Change Option in the Alter Statement

Adding Specific Kinds of Data

• Recording IP Addresses in a Database Table as an Integer

• Backing Up Table Data in MySQL - Database Dump to Text File
• Import Tab-Delimited Text File Data into MySQL Database Table
• MySQL Query Output to Text File