Workbench tips for setting up a small

1.Workbench cannot delete and update data in bulk:

Because the default security setting for Workbench is not to batch update the table

Menu: Edit,preferences...,sql Editor, remove the hook from Safe Updates (rejects Updates and deletes with no restrictions)

2. Large batch query, query time timeout:Error code:2013. Lost connection to MySQL server during querysolution:

Edit,preferences, SQL Editor,dbms connection keep-alive interval (in seconds): 600 changed to 6000 or greater; DBMS Connection read Time Out ( In seconds): 600; Change to 6000 or greater;

3.workbench also has shortcut keys, installation directory of Data/main_menu.xml; You can modify the default shortcut keys;

4. Same as Plsql also have the Submit and rollback button, just default does not open, to the official website for a long time to find clues to open the submit and rollback button;

Connect an official website: https://dev.mysql.com/doc/workbench/en/; You can view the official document.