Filling Insert Row With Values From A Displayed Row

[tyrathect]

It would be nice to have a feature to fill the fields of the insert row with values from another row.

I often encounter the problem to insert a new row that differs only little from those in an existing row. So, if the insert row could be pre-filled with those values, I'd only have to apply those small changes and I'd be good.

True, I could use “INSERT… SELECT…” and change the values afterwards, but I'd have to specify the whole column list just in order to leave out the fields with unique indexes. Having some tables with 20-30 columns, this is quite a bother, too.

[peterlaursen]

I think we have an identical or almost identical request registered here:

http://code.google.com/p/sqlyog/issues/det…319&q=merge

[tyrathect]

peterlaursen wrote on Oct 2 2007, 11:31 AM:

I think we have an identical or almost identical request registered here:

http://code.google.com/p/sqlyog/issues/det…319&q=merge

Hm, not sure about this, I think my request is somewhat more simple: In the “Table Data” tab, data from an existing row of the same table should be able to be filled into the insert row (last row, usually empty at first), in contrast to typing it in by hand.

Btw, I just noticed there are now browse buttons in the table data tab 🙂 Thanks, I really missed this a lot before ^____^

[peterlaursen]

OK .. something like a spreadsheet 'autofill' thing then?!

[tyrathect]

Hmmm… not sure, I'm not too familiar with spreadsheets and Excel/Calc's capabilities there ^^;;;

I'm not sure if I'm making myself clear about the feature I'm suggesting =^^= I'm imagining something like this: in the table data tab, right-clicking a row will bring up the usual popup menu but with one or two additional options, “Copy row data to insert row” and/or “Copy cell data to insert row” or something. Then I could edit the (copied) data in the insert row and hit the “Save changes” button which will at last physically insert the new row into the table.

[Marjolein Katsma]

tyrathect wrote on Nov 20 2007, 02:43 PM:

I'm not sure if I'm making myself clear about the feature I'm suggesting =^^= I'm imagining something like this: in the table data tab, right-clicking a row will bring up the usual popup menu but with one or two additional options, “Copy row data to insert row” and/or “Copy cell data to insert row” or something. Then I could edit the (copied) data in the insert row and hit the “Save changes” button which will at last physically insert the new row into the table.

It's certainly clear to me 😉 This is exactly what I'd like to see as well – it would save a lot of typing and navigating through fields – just copy row, and change the two fields or so that would really need to be different would be really helpful!

[Author]

Posts