MySQL SQL Editor
The MySQL SQL editor provided by RazorSQL includes features to make MySQL development easier. Users can create, edit, and drop MySQL stored procedures, functions, and triggers. Also provided are auto lookup and completion tools to make writing SQL statements faster and easier. Listed below are the features of the MySQL SQL Editor.
- MySQL specific syntax highlighting
- SQL syntax highlighting
- SQL function lookup
- Auto table lookup and completion
- Auto column lookup and completion
- Extensive find, replace, and find / replace in files functionality
- Bracket, parenthesis, and brace auto matching
- Support for parameterized queries
- SQL Formatter
- Execute, Execute Fetch All, and Execute Batch functions
- Multi-Tabular Display of Query Results
- Sortable Query Results
- Filterable Query Results
- Searchable Query Results
- SQL History for All Queries, and Query Logging Per Connection
- Query navigator for displaying a clickable display of queries in the editor
- Key Ahead functionality for one-click population of user-defined text
- Built-in and Custom User Templates
- Connection Keep-Alive
- Plugin API (Allows users to add custom functionality to RazorSQL)
The MySQL SQL editor will automatically configure MySQL specific syntax highlighting on connection to a MySQL database. This is a superset of the default SQL syntax highlighting. The editor then highlights MySQL specific keywords and functions, and provides other options such as the ability to select the current database from a dropdown.
