![]() Return "\n".join("- " line for line in lines)ġ /*! MySQL-specific code */ SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE. Return "\n".join((line if line.startswith("- ") else line) for line in lines) ModuleInfo = DefineModule(name='Comment', author="Scott Hamilton", "Un/Comment Selection") Windows: DISK_NAME:\path_to_mysql_workbench\MySQL Workbench 6.3 CE\data\main_menu.xml The MySQL Server’s process should have write access to the target folder containing the target CSV file. MacOs: /Applications/MySQLWorkbench.app/Contents/Resources/data/main_menu.xml */įROM contacts Linux: /usr/share/mysql-workbench/data/main_menu.xml Purpose: To show a comment that spans multiple lines in your SQL statement. * Purpose: To show a comment that spans multiple lines in your SQLįROM contacts SELECT contact_id, last_name, first_name /* Author: # comment goes here - comment goes here /* comment goes here */ SELECT contact_id, last_name, first_nameįROM contacts SELECT /* Author: */ contact_id, last_name, first_nameįROM contacts SELECT contact_id, last_name, first_name /* Author: */įROM contacts SELECT contact_id, last_name, first_name - Author: įROM contacts SELECT contact_id, last_name, first_name # Author: įROM contacts SELECT contact_id, last_name, first_name this is a comment but requires a whitespace/tab/newline after the double - MySQL: Comments within SQL If you’d like to see video tutorial and fix the issue, then refer the below. Follow the below videos for MySQL Server and Workbench: Create a new database and table in MySQL Workbench Create a new database in MySQL Video Tutorial. Mysql> SELECT 1 /* this is an in-line comment */ 1 This will connect to MySQL Server: Now, go to start, type MySQL Workbench and open it. ![]() Mysql> SELECT 1 1 - This comment continues to the end of line A 'change' entry has been added to the 5.2.7 changelog: In the Administrator tab of MySQL Workbench the Data Dump (Export/Import Data) feature now uses the -comments parameter when executing an import or export operation. Mysql> SELECT 1 1 # This comment continues to the end of line Previous Post Next Post How do you comment in mysql workbench
0 Comments
Leave a Reply. |