MySQL Workbench can be used to generate SQL, most typically as either
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
DELETE", and "
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.