Learning phpMyAdmin

Limitations Of phpMyAdmin In Hosted Environments Setting The Server Connection Collation Choosing The Right Column Types Collation, Character Sets, And Storage

Creating A Database Setting Up A User Account Defining A Table Amending The Table Structure Inserting Data Manually Using The Browse Tab

Copying A Column Definition To Another Table With Central Columns Importing Data From Excel Or A CSV File Importing Data From An OpenDocument Spreadsheet Importing Data From A SQL Dump File Exporting A Database The Quick Way Exporting Multiple Databases Creating A Custom Export For A Single Database Exporting Partial Data Enhanced Export Features In phpMyAdmin 4.5

Understanding Foreign Key Constraints Converting The Table Engine Setting Up A Foreign Key Constraint Removing A Foreign Key Constraint

Performing A Simple Search Using Query By Example (QBE) To Perform A Simple Search Finding And Replacing Text In A Column Using QBE To Set Multiple Conditions In A WHERE Clause Joining Multiple Tables With QBE Building Queries Manually On A Single Table Building A Query Manually On Multiple Tables Saving Frequently Used Queries With Bookmarks Using A Variable With A Bookmarked Query Using Variables With Bookmarks In phpMyAdmin 4.5 Using Named Parameters In A Query Running Queries From The Console New Console Options In phpMyAdmin 4.5 Syntax Checker In phpMyAdmin 4.5

Creating A View Editing A View Creating A Stored Procedure Creating A Stored Function Creating A Trigger Scheduling Events

Profiling And Explaining Queries Analyzing Table Structure Normalizing A Table Inspecting Server Performance Other Changes In phpMyAdmin 4.5 Where Next