![]() ![]() As above use arrow-keys to select one, press ENTER and the selected one is inserted.Ĭtrl+Shift+Space keyboard shortcut that will display the parameter-list of a routine when the cursor is positioned inside it. When cursor is placed in the editor pane pressing CTRL+SPACE always opens a small window with a list of ALL keywords and functions. Use arrow-keys to select one, press ENTER and the selected one is inserted. Press CTRL+ENTER and a small window opens with a list of keywords and functions starting with this/these character(s). These inputs are functions, keywords and database objects from the selected database as well.Īs above type in a single or a few character(s) in the editor pane. For each time you press the TAB key autocomplete will switch between all possible inputs starting with this/these character(s). Try highlighting a database in Object Browser and type in a single or a few characters in the editor pane. Try typing "ABS(" yourself.įinally when only one possible match is left, autocomplete will tell you and you only need to press TAB to insert. Also typing the name of a function followed by "(" will display the parameter list of that function. And type a "mytable." and a list of columns in that table is displayed. ![]() ![]() For instance try typing a database name like "mydb." to see the list of tables in the 'mydb'-database. Whenever you type in an object name followed by "." the available object in the level below will pop up in a small window from where you can select using arrow-keys and ENTER. SQLyog is shipped with a database with the names of MySQL keywords and functions and for every connection that it uses it will retrieve and maintain a list of the object names for each connection.Īlso with long and/or awkward object names this feature reduces the possibility of misspelling and thus saves you time and reduce the risk of accidentally executing wrong queries and reaching wrong conclusions.Īutocomplete basically functions in four and independent different ways. The feature makes use of a small database engine that is built into SQLyog. After about a year of selling the product, I left my job to become and indipendent developer.The purpose of the autocomplete feature of SQLyog is to make it ease to type any type of database object (tables, columns etc.) names, and the names of MySQL keywords and functions. I started developing SQLPro as a tool I could use for connecting to Microsoft SQL Server databases without the need to Remote Desktop into a Windows OS to use the SSMS (SQL Server Management Studio) tool. While working for the company, I personally owned (and prefered) a MacBook. SQLPro was started as a side project while I worked for a company developing products for Microsoft Windows. Cross platform (macOS, iOS and Windows).Full dark mode & light mode support, along with custom themes.Improved query error detection (errors in queries will be underlined red).The ability to run multiple queries at one time.Syntax highlighting & Autocomplete (sometimes called intellisense).SQLPro includes all of the basic features someone working with databases would expect, along with many advances features that place SQLPro ahead of the competition. It allows users to connect to multiple databases platforms including MySQL, PostgreSQL, Microsoft SQL Server, Oracle and SQLite. SQLPro Studio is a multi-platform database client. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |