Home > Articles > Data > MySQL

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

3.4 The MySQL Table Editor

MySQL Query Browser has a table editor facility that enables you to create tables or edit the definitions of existing tables. To access the MySQL Table Editor, right-click on a table name in the database browser and select Edit Table. The MySQL Table Editor also can be accessed from the MySQL Administrator program: Select the Catalogs section of the main window, select a database, and then right-click on a table name and select Edit Table.

The MySQL Table Editor provides a graphic interface for manipulation of table definitions, as shown in Figure 3.2.

Figure 3.2

Figure 3.2 MySQL Table Editor.

The MySQL Table Editor enables you to perform the following tasks:

  • Create new tables or edit the structure of existing tables
  • Rename tables or move tables to a different database
  • Change table options, such as the storage engine, character set and collation, or table comment
  • Specify column definitions (name, data type, and attributes)
  • Define indexes and foreign keys

The Options dialog has an Editors section that enables you to set MySQL Table Editor preferences. See Section 3.6, "The Options Dialog."

  • + Share This
  • 🔖 Save To Your Account