Manual Entry from Persp.Table to MySQL

You can set the notes column to editable like this:
image

I would create your sql update statement in a named query then run it with system.db.runNamedQuery in the table's onEditCellCommit component event. Refresh the table after you run the query with self.refreshBinding('props.data')