MySQL Workbench can be used to generate SQL, most typically as either
INSERT or SELECT queries.
Below are the most common methods to generated 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 will allow
creating "SELECT All",
"INSERT", "UPDATE",
"DELETE", and "CREATE"
queries. And with the option to either send these queries 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.
© 2013, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.