Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering phpMyAdmin 2.11 for Effective MySQL Management
  • Table Of Contents Toc
Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Buy this Book
close
close
Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Buy this Book

Overview of this book

Table of Contents (25 chapters)
close
close
close
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Icon
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
Preface
Icon
Preface
Lock Free Chapter
1
Introducing phpMyAdmin
Icon
Introducing phpMyAdmin
Icon
PHP and MySQL: The Leading Open-Source Duo
Icon
What is phpMyAdmin?
Icon
History
Icon
Awards
Icon
phpMyAdmin Features Summary
Icon
Summary
2
Installing phpMyAdmin
Icon
Installing phpMyAdmin
Icon
System Requirements
Icon
Downloading the Files
Icon
Installation
Icon
First Connection Configuration
Icon
Multi-Server Configuration
Icon
Advanced Authentication
Icon
Security
Icon
Upgrading phpMyAdmin
Icon
Summary
3
Interface Overview
Icon
Interface Overview
Icon
Panels and Windows
Icon
Language Selection
Icon
Themes
Icon
Left Panel
Icon
Right Panel
Icon
Query Window
Icon
Site-Specific Header and Footer
Icon
MySQL Documentation Links
Icon
Summary
4
First Steps
Icon
First Steps
Icon
Database Creation
Icon
Creating Our First Table
Icon
Manual Data Insertion
Icon
Browse Mode
Icon
Creating an Additional Table
Icon
Summary
5
Changing Data
Icon
Changing Data
Icon
Edit Mode
Icon
Multi-Row Editing
Icon
Editing the Next Row
Icon
Deleting Data
Icon
Deleting Tables
Icon
Deleting Databases
Icon
Summary
6
Changing Table Structures
Icon
Changing Table Structures
Icon
Adding a Field
Icon
Editing Field Attributes
Icon
TEXT
Icon
BLOB (Binary Large Object) Fields
Icon
ENUM and SET
Icon
DATE, DATETIME, and TIMESTAMP
Icon
Bit
Icon
Index Management
Icon
Summary
7
Exporting Structure and Data
Icon
Exporting Structure and Data
Icon
Dumps, Backups, and Exports
Icon
Database Exports
Icon
Table Exports
Icon
Selective Exports
Icon
Multi-Database Exports
Icon
Saving the Export File on the Server
Icon
Memory Limits
Icon
Summary
8
Importing Structure and Data
Icon
Importing Structure and Data
Icon
Limits for the Transfer
Icon
Importing SQL Files
Icon
Importing CSV Files
Icon
Web Server Upload Directories
Icon
Summary
9
Searching Data
Icon
Searching Data
Icon
Single-Table Searches
Icon
Complete Database Search
Icon
Summary
10
Table and Database Operations
Icon
Table and Database Operations
Icon
Table Maintenance
Icon
Changing Table Attributes
Icon
Renaming, Moving, and Copying Tables
Icon
Multi-Table Operations
Icon
Database Operations
Icon
Summary
11
The Relational System
Icon
The Relational System
Icon
Relational MySQL?
Icon
Linked-Tables Infrastructure
Icon
Defining Relations with the Relation View
Icon
Defining Relations with the Designer
Icon
Benefits of the Defined Relations
Icon
Column-Commenting
Icon
Summary
12
Entering SQL Commands
chevron up
Icon
Entering SQL Commands
Icon
The SQL Query Box
Icon
The Query Window
Icon
Multi-Statement Queries
Icon
Pretty Printing (Syntax-Highlighting)
Icon
The SQL Validator
Icon
Summary
13
The Multi-Table Query Generator
Icon
The Multi-Table Query Generator
Icon
Choosing Tables
Icon
Column Criteria
Icon
Automatic Joins
Icon
Executing the Query
Icon
Summary
14
Bookmarks
Icon
Bookmarks
Icon
Creating a Bookmark after a Successful Query
Icon
Storing a Bookmark before Sending a Query
Icon
Multi-Query Bookmarks
Icon
Recalling from the Bookmarks List
Icon
Public Bookmarks
Icon
The Default Initial Query for a Table
Icon
Bookmark Parameters
Icon
Executing Bookmarks by Browsing the pma_bookmark Table
Icon
Summary
15
System Documentation
Icon
System Documentation
Icon
The Database Print View
Icon
The Selective Database Print View
Icon
The Table Print View
Icon
The Data Dictionary
Icon
Relational Schema in PDF
Icon
Summary
16
MIME-Based Transformations
Icon
MIME-Based Transformations
Icon
The MIME Column's Settings
Icon
Requirements for Image Generation
Icon
Examples of Transformations
Icon
Summary
17
Character Sets and Collations
Icon
Character Sets and Collations
Icon
Language Files and UTF-8
Icon
Versions of MySQL Prior to 4.1.x
Icon
MySQL 4.1.x and Later
Icon
Kanji Support
Icon
Summary
18
MySQL 5.0 Features
Icon
MySQL 5.0 Features
Icon
Observations on the History of MySQL 5.0
Icon
Views
Icon
Routines: Stored Procedures and Functions
Icon
Triggers
Icon
Information_schema
Icon
Profiling
Icon
Summary
19
MySQL Server Administration
Icon
MySQL Server Administration
Icon
Entering the Server View
Icon
Database Information
Icon
Server Operations
Icon
Summary
20
Troubleshooting and Support
Icon
Troubleshooting and Support
Icon
System Requirements
Icon
Base Configuration
Icon
Solving Common Errors
Icon
Seeking Support
Icon
Contributing to the Project
Icon
Future phpMyAdmin Versions
Icon
Summary

Chapter 12. Entering SQL Commands

This chapter explains how we can enter our own SQL commands (queries) into phpMyAdmin and how we can keep a history of those queries.

The SQL Query Box

phpMyAdmin allows us to accomplish many database operations via its graphical interface, but sometimes we have to rely on SQL query input to achieve complex operations. Here are examples of complex queries: 

SELECT department, AVG(salary) FROM employees GROUP by department HAVING years_experience > 10; SELECT FROM_DAYS(TO_DAYS(CURDATE()) +30);

The query box is available from a number of places within phpMyAdmin.

The Database View

We encounter our first query box when going to the SQL menu available in the Database view.

This box is simple: we type in it some valid (hopefully) MySQL statement and click Go. Usually, we don't have to change the standard SQL delimiter, which is a semicolon, but a Delimiter dialog exists in case we need to—this is covered in Chapter 18.

For a default query to appear in this box, we...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering phpMyAdmin 2.11 for Effective MySQL Management
End of Section 12
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon