MySQL Configuration SQL Assistant tips

The previous development has been using SQL Server database, prompting the plugin to use SQL Assistant, writing the kicker is quite efficient. This time the company transformation to use MySQL database, trial MySQL Workbench, MySQL Query browser and navicate and other tools, feel writing script hints are not very useful. Later read SQL Assistant official online said SQL Assistant is support MySQL Workbench and MySQL query browser, reinstall SQL Assistant, check MySQL Workbench option, after installation is complete, The effects and the experience on SQL Server were too different, and then slowly tinkering and discovering that SQL Assistant comes with a SQL Editor Script Editor, and the prompts in SQL Server are exactly the same.

Now to record the configuration of the process: the first step in the SQL Assistant taskbar icon Right click, select SQL Editor, open the editor, such as the second step, the connection configuration for MySQL, Connection type to choose MySQL Nati Ve,mysql DLL to select a file named Libmysql.dll (the file will be shared at the end of the article), click Connect, open the database, such as the third step, enter the script, see the effect is now SQL Assistant v7. 2 and the article need DLL link share under the Baidu Cloud address, extract password: 3HA3

MySQL Configuration SQL Assistant tips