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. 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.
0 Comments
Leave a Reply. |