Searching Data | Mastering phpMyAdmin 2.11 for Effective MySQL Management

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Credits

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

Preface

Preface

Free Chapter

Introducing phpMyAdmin

Introducing phpMyAdmin

PHP and MySQL: The Leading Open-Source Duo

What is phpMyAdmin?

History

Awards

phpMyAdmin Features Summary

Summary

Installing phpMyAdmin

Installing phpMyAdmin

System Requirements

Downloading the Files

Installation

First Connection Configuration

Multi-Server Configuration

Advanced Authentication

Security

Upgrading phpMyAdmin

Summary

Interface Overview

Interface Overview

Panels and Windows

Language Selection

Themes

Left Panel

Right Panel

Query Window

Site-Specific Header and Footer

MySQL Documentation Links

Summary

First Steps

First Steps

Database Creation

Creating Our First Table

Manual Data Insertion

Browse Mode

Creating an Additional Table

Summary

Changing Data

Changing Data

Edit Mode

Multi-Row Editing

Editing the Next Row

Deleting Data

Deleting Tables

Deleting Databases

Summary

Changing Table Structures

Changing Table Structures

Adding a Field

Editing Field Attributes

TEXT

BLOB (Binary Large Object) Fields

ENUM and SET

DATE, DATETIME, and TIMESTAMP

Bit

Index Management

Summary

Exporting Structure and Data

Exporting Structure and Data

Dumps, Backups, and Exports

Database Exports

Table Exports

Selective Exports

Multi-Database Exports

Saving the Export File on the Server

Memory Limits

Summary

Importing Structure and Data

Importing Structure and Data

Limits for the Transfer

Importing SQL Files

Importing CSV Files

Web Server Upload Directories

Summary

Searching Data

Searching Data

Single-Table Searches

Complete Database Search

Summary

Table and Database Operations

Table and Database Operations

Table Maintenance

Changing Table Attributes

Renaming, Moving, and Copying Tables

Multi-Table Operations

Database Operations

Summary

The Relational System

The Relational System

Relational MySQL?

Linked-Tables Infrastructure

Defining Relations with the Relation View

Defining Relations with the Designer

Benefits of the Defined Relations

Column-Commenting

Summary

Entering SQL Commands

Entering SQL Commands

The SQL Query Box

The Query Window

Multi-Statement Queries

Pretty Printing (Syntax-Highlighting)

The SQL Validator

Summary

The Multi-Table Query Generator

The Multi-Table Query Generator

Choosing Tables

Column Criteria

Automatic Joins

Executing the Query

Summary

Bookmarks

Bookmarks

Creating a Bookmark after a Successful Query

Storing a Bookmark before Sending a Query

Multi-Query Bookmarks

Recalling from the Bookmarks List

Public Bookmarks

The Default Initial Query for a Table

Bookmark Parameters

Executing Bookmarks by Browsing the pma_bookmark Table

Summary

System Documentation

System Documentation

The Database Print View

The Selective Database Print View

The Table Print View

The Data Dictionary

Relational Schema in PDF

Summary

MIME-Based Transformations

MIME-Based Transformations

The MIME Column's Settings

Requirements for Image Generation

Examples of Transformations

Summary

Character Sets and Collations

Character Sets and Collations

Language Files and UTF-8

Versions of MySQL Prior to 4.1.x

MySQL 4.1.x and Later

Kanji Support

Summary

MySQL 5.0 Features

MySQL 5.0 Features

Observations on the History of MySQL 5.0

Views

Routines: Stored Procedures and Functions

Triggers

Information_schema

Profiling

Summary

MySQL Server Administration

MySQL Server Administration

Entering the Server View

Database Information

Server Operations

Summary

Troubleshooting and Support

Troubleshooting and Support

System Requirements

Base Configuration

Solving Common Errors

Seeking Support

Contributing to the Project

Future phpMyAdmin Versions

Summary

Chapter 9. Searching Data

Here we present mechanisms that can be used to find the data we are looking for instead of just browsing tables page-by-page and sorting them. This chapter covers single-table and whole database searches. Chapter 13 is a complement to this chapter and presents multi-table query by example.

Single-Table Searches

This section describes the Search sub-page where single-table search is available.

Daily Usage of phpMyAdmin

The main use for the tool for some users is with the Search mode, for finding and updating data. For this, the phpMyAdmin team has made it possible to define which sub-page is the starting page in Table view, with the $cfg['DefaultTabTable'] parameter. Setting it to 'tbl_select.php' defines the default sub-page to search.

With this mode, application developers can look for data in ways not expected by the interface they are building, adjusting and sometimes repairing data.

Entering the Search Sub-Page

The Search sub-page can be accessed by clicking the...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

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

Search

Your notes and bookmarks