MyEclipse Logo
 

MyEclipse MySQL 5 Feature Overview

Outline
download the latest MyEclipse version

help and support
 

1. Preface

This document was written using MyEclipse and MySQL 5.0. All screenshots are based upon the default user interface settings for MyEclipse and Windows XP. However, if you experience difficulty with the instruction of this document, please see the User Feedback section for how to provide feedback to the MyEclipse documentation team.


 

2. Requirements

Below is a list of requirements for this Tutorial:

  1. MyEclipse (see Resources for a download link)
  2. MySQL Server 5.0 or above

3. Introduction

The extended MySQL features described in this document are available only to MyEclipse Professional subscribers.
Extended features currently cover Procedures, Functions and Triggers and Views. More features will be added in future releases.

Note: Users using versions of MySQL prior to 5.0 will not see any new features as these entities are only implmented in MySQL 5.0 and up.


Figure 1. Overview of extended Nodes supported by MyEclipse


4. Node Types & Features


4.1 View



Figure 2. Generate DDL for Views


Figure 3. View Info


4.2 Procedure



Figure 4. Open Procedure


Figure 5. Procedure Info


Figure 6. Run Procedure


4.3 Function



Figure 7. Open Function


Figure 8. Function Info


Figure 9. Run Function


4.4 Trigger



Figure 10. Open Trigger


Figure 11. Trigger Info


4.5 Show Details

The "Show Details" action returns additonal information for a database entity and displays it in the SQL Results view. It is demonstrated here with a Procedure node.


Figure 12. Show Details

5. User Feedback

If you have comments or suggestions regarding this document please submit them to the MyEclipse Documentation Forum. 


6. Resources