MySQ
MySQL Tested for version 3.23, 4, 5, 8, 9
Overview JDBC Drivers Features Supported Objects Download

MySQL

MySQL object type support.

The following table shows the database specific support in DbVisualizer for MySQL organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object TypeActionsViewers
Image Image Databases
 Create Database Databases
Image Image Catalog
 Export Database[1], Drop Database Database
Image Image Tables
 Create Table[1], Import Table Data[1] References, Tables
Image Image Table
 Alter Table[1], Create Trigger, Export Table[1], Import Table Data[1], Script: Script Table, Analyze Table[2], Check Table[2], Checksum Table[3], Create Index, Drop Table, Empty Table, Load Table Data, Optimize Table[2], Rename Table, Repair Table[2] Navigator[1], References, Data, Columns, DDL[1], Grants, Indexes, Info, Native DDL, Primary Key, Row Count, Row Id, Triggers[4]
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Indexes
   Indexes
Image Image Index
 Drop Index Index
Image Image Triggers[4]
   Triggers
Image Image Trigger
 Export Trigger[1], Drop Trigger Trigger Editor[1], Info
Image Image Views[4]
   Views
Image Image View
 Export View[1], Script: Script View, Drop View, Rename View Data, Columns, DDL[4][1], Grants, Info, Row Count
Image Image Columns
   Columns
Image Image Column
   Column
Image Image Stored Procedures[4]
 Create Procedure Stored Procedures
Image Image Procedure
 Export Procedure[1], Script: Script Procedure, Drop Procedure Procedure Editor[1], Info
Image Image User Functions[4]
 Create Function User Functions
Image Image Function
 Export Function[1], Script: Script Function, Drop Function Function Editor[1], Info
Image Image Triggers[4]
   Triggers
Image Image Trigger
 Export Trigger[1], Drop Trigger Trigger Editor[1], Info
Image Image Events[5]
 Create Event, Start/Stop Event Scheduler Events
Image Image Event
 Alter Event, Drop Event, Enable/Disable Event, Rename Event Info
Image Image DBA Views
   DBA
Image Image Users
 Create User Users
Image Image User
 Drop User Privileges, Show Grants
Image Image Privileges[2]
   Server Privileges
Image Image Processes
   Processes
Image Image Process
 Kill Session Process
Image Image Status
   Charset[2], Collation[2], Replica Status[7], Replicas[7], Session SQL Mode[2], Slave Hosts[6], Slave Status[6], Status, Variables
Image Image Storage Engines[2]
   Table Engines
Image Image Table Engine
   Mutex, Status
Image Image Errors and Warnings[4]
   Errors, Warnings
[1] DbVisualizer Pro
[2] Version 4.1 and later
[3] Version 4.2 and later
[4] Version 5.0 and later
[5] Version 5.2 and later
[6] Version 4.1 to 8.4.9
[7] Version 9.0 and later