O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we get an overview of:

  • How to add fields, including special field types such as TEXT, BLOB, ENUM, and SET
  • How to use a calendar pop up for DATE, DATETIME, and TIMESTAMP fields
  • How to upload binary data into a BLOB field
  • How to manage indexes (multi-field and full-text), and get feedback from MySQL about which indexes are used in a specific query

In Chapter 7, we'll learn how to export a tables structure and data for backup purposes, or to use as a gateway to another application.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required