Uncategorized

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 *