pycharm: assistance on mysql insert queries


  • select the insert query
  • right-click -> edit as table
  • you can modify your insert query visually


this is super helpful for long queries, where it is very tedious to match column to value.



another option is

  • click lightbulb
  • edit generic sql fragment

Leave a Reply

Your email address will not be published. Required fields are marked *