1. Open
.2. Choose the
tab.3. Right click the
then choose New Connection....
4. The New Connection Wizard will appear, choose the MySQL (Connection/J drive) then hit the
button.
5. Fill up the field(s) for the MySQL connection, then click
button (leave the Database field as blank).
6. Hit
button.
7. On the
tab choose the then double click the 
to show the list of all databases in the MySQL server.8. Select any database and any table table on the listed items.
9. Right click the table (e.g. studentdb.tblstudents) then choose Execute Command...
10. The SQL Command window will appear, type any query then hit
or press Ctrl + Shift + E to run. Sample result
No comments:
Post a Comment