MySQL Workbench can be used to generate SQL, most typically as either
INSERT statements or
Below are the most common methods of generating SQL statements in MySQL Workbench.
Right-clicking on a table or column name within the schema view will offer many different SQL generating options.
For example, right-clicking on a table name allows creating
SELECT All", "
CREATE" statements, and with the option to
either send these statements to the system's clipboard, or to
the SQL Editor window.
Right-clicking on a field within a cell in the SQL Editor offers the "Copy Row Content" and "Copy Field Content" options, and includes the option to leave the chosen values unquoted.
All of the MySQL Workbench Export options include the option to export as SQL.
Copyright © 2006, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices