Summary

mysql_sql_workspace._applyStagedChanges calls generateMutationPlan() without primaryKeys or columnDataTypes. WHERE is every displayed column. Fallback table name is the literal table. Statements run in a loop with no START TRANSACTION (Table Browser wraps a transaction). Mid-loop failure leaves a partial write.

Scope

• Resolve a simple FROM via getTableSchema. If no PK or not a single-table SELECT, disable Save.
• Pass columnDataTypes.
• Wrap like Table Browser: START TRANSACTION / statements / COMMIT / ROLLBACK.
• Tests: JOIN / FROM a, b do not mutate; simple SELECT * FROM db.t uses the PK.

Out of scope

• Postgres fix(postgres): SQL result-grid Save must use PK and column types (or stay read-only) #786 / SQLite fix(sqlite): SQL result-grid Save must use PK, types, and a transaction #795 — same helper; OK to share a fix.