Hi, PMA have this problem when importing data from file in table containing primary key.If the data imported contains same value then error is shown for duplicate entry in table. After considering answer given by Bill Karwin on stackoverflow link http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update . I suggest to keep a check box for ignoring or replacing the new value which is already there in import file as imposing It permanently can create some mess. Suggestions are most welcome. Thanks and Regards.
Rakesh,
On Thu Feb 12 2015 at 7:10:21 PM Rakesh Kumar rakeshkumar4294@gmail.com wrote:
Hi, PMA have this problem when importing data from file in table containing primary key.If the data imported contains same value then error is shown for duplicate entry in table. After considering answer given by Bill Karwin on stackoverflow link http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update . I suggest to keep a check box for ignoring or replacing the new value which is already there in import file as imposing It permanently can create some mess.
If I understand correctly the old rfe #675, it is more about merging/altering of table structure as per the new table structure perceived from the sql dump, not just update of data rows with duplicate primary key values. As pointed out by a comment on #675, it is similar to generating an alter table diff (see https://sourceforge.net/p/phpmyadmin/feature-requests/246/ ), but #675 would require parsing of sql dump as well.
Maybe a new feature request could be opened for ignoring or replacing the new values on finding duplicate primary key.
-- Regards
Atul Pratap SIngh http://blog.atulsisodia.in/
Atul, I clearly misunderstood the problem and I would like to work on the original problem (merging/altering of table structure) including the update of data rows with duplicate primary rows. Thanks for the link of related feature request and reply. Regards.
On 12 February 2015 at 23:00, Atul Pratap Singh <atulpratapsingh05@gmail.com
wrote:
Rakesh,
On Thu Feb 12 2015 at 7:10:21 PM Rakesh Kumar rakeshkumar4294@gmail.com wrote:
Hi, PMA have this problem when importing data from file in table containing primary key.If the data imported contains same value then error is shown for duplicate entry in table. After considering answer given by Bill Karwin on stackoverflow link http://stackoverflow.com/questions/548541/insert-ignore-vs-insert-on-duplicate-key-update . I suggest to keep a check box for ignoring or replacing the new value which is already there in import file as imposing It permanently can create some mess.
If I understand correctly the old rfe #675, it is more about merging/altering of table structure as per the new table structure perceived from the sql dump, not just update of data rows with duplicate primary key values. As pointed out by a comment on #675, it is similar to generating an alter table diff (see https://sourceforge.net/p/phpmyadmin/feature-requests/246/ ), but #675 would require parsing of sql dump as well.
Maybe a new feature request could be opened for ignoring or replacing the new values on finding duplicate primary key.
-- Regards
Atul Pratap SIngh http://blog.atulsisodia.in/
Dive into the World of Parallel Programming. The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel