yoichiro / chrome_mysql_admin

ChromeMyAdmin provides you the administration GUI of MySQL server. It is like phpMyAdmin, Sequel Pro.
https://www.eisbahn.jp/chrome_mysql_admin
Apache License 2.0
140 stars 33 forks source link

Add a new operation to copy a row #72

Closed yoichiro closed 5 years ago

yoichiro commented 5 years ago

As the title. I received the request from some user. The conversation is the followings:

From the user:

Idea 1: don't copy item no. 1 Without over-thinking it: can you not fill in the first item in the row? I usually use that first index as my pk. Copy every item except the first?

That's my first thought - but obviously, it isn't a complete solution.

Idea 2: don't save anything to the table - just open a new window with all the information filled in My second idea: don't yet copy the row into the table -- just put all the values into a new edit pop-up window (what is that called?). Only once I scroll down and hit "Insert" will it save to the table -- where any conflicts with pk will be caught.

Step 1: Highlight row I want to copy Step 2: Hit "copy" icon (non-existent now) Step 3: Edit box opens with all of the row content (id 126 in my example) - but nothing saves to table yet. Step 4: user edits items and hits "Insert" for it to save. In my case - I would edit id 126 because that's my pk.

My answer:

Yes, your idea is great! In fact, I also was thinking the same way. And, its idea is lightweight way at implementing as me.

yoichiro commented 5 years ago

I implemented this feature on the version 4.9.0.