14 Feb
2015
14 Feb
'15
7:50 a.m.
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(a)gmail.com
wrote:
>
> Rakesh,
>
> On Thu Feb 12 2015 at 7:10:21 PM Rakesh Kumar <rakeshkumar4294(a)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(a)lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
>
--
Rakesh Kumar-B.Tech CSE ,ISM Dhanbad