Inserting data in SQLPro

Question

Is there a way to insert data here, for example, by clicking "Add new row" or double clicking the entry? I'm used to this feature in SequelPro, and it seems a bit crude to not allow a simple GUI way to add in a new row (the reason why I'm using this is so I don't have to manually type in INSERT statements:

This could be one way. You could remove `LIMIT 100` and check if resultset will allow inline edit. — Lukasz Szozda, Jun 22 '18 at 18:21
@LukaszSzozda it allows editing, but seems very painful adding new rows. — David542, Jun 22 '18 at 18:22
@JacekCz got rid of it and started using Navicat which is quite a bit better. — David542, Jun 22 '18 at 20:13

score 0 · Answer 1 · answered Oct 20 '19 at 12:40

Two easy ways:

Right click anywhere in the table, without selecting a certain row. Choose Add new Row
Right click any row, and choose Duplicate Row, this creates a new row with duplicated data, and Null id if you have a primary key. This is not committed to the database until you fix the data that you want. Change what you want and press Enter.

Ta da! You have your data

Inserting data in SQLPro

1 Answers1