|
Contents
Index
<< Previous
Next >>
PDF
SQL Editor
|
|
Menu: View / SQL Editor
Switches the view to the SQL Editor.
The SQL Editor allows to write one or multiple SQL statements and execute the directly. The result sets of queries will be shown below to syntax highlighting editor.
It's possible to execute all statements at once, execute the marked code or the execute the SQL statement where it cursor is located in.
To get help about the SQL commands MySQL-Front offers a context sensitive SQL help. Just pressing <F1> to get a help to the keyword the cursor is located.
Attension:
| All changes sent to the database by using the SQL Editor will not be overtaken automaticly inside MySQL-Front. The Refresh All feature has to be called to update MySQL-Front.
|
Note:
| To get the context sensitive help of the SQL statements the MySQL has to support the HELP feature. This requires MySQL version 4.1 or higher. Additional the help tables of the mysql database has to be filled. This can be made by executing the fill_help_tables.sql script attached with the MySQL database installation. To do this you need full access to the mysql database or you have to ask the database administrator to fill this tables.
|
|
|
