SQL manager in CodeLobster IDE

Most of websites store data in database to provide full-fledged working and quick and convenient processing of information. CodeLobster IDE has a built-in manager that allows easy and convenient fulfilment of all necessary operations with databases.

 SQL manager is a part of CodeLobster IDE - Professional version

SQL manager has the following abilities to work with MySQL databases:

• SQL autocomplete
• Structure (fields) editing
• Data editing
• Export wizard

For quick writing SQL queries Codelobster analyses code written by you and offers only appropriate database object names and syntax for their completion.
In order to enable intelligent autocomplete to work, you should be connected to your databases.

SQL keywords autocomplete:

Tables autocomplete:

Fields autocomplete:

For every table of database the manager allows to review the structure and change types of fields.

There is a very powerful special grid for direct data editing.

You can export all data and base structure or structure of a separate table using custom wizard.