realRO Posted December 25, 2013 Group: Members Topic Count: 29 Topics Per Day: 0.01 Content Count: 84 Reputation: 0 Joined: 12/24/13 Last Seen: June 13, 2017 Share Posted December 25, 2013 Requesting a SQL import Specific ID I will import, example account 100000 << I want to import it. And if I export it back, will it overwritten my old SQL? Other accounts wont be affected? Thanks Bumpy. Quote Link to comment Share on other sites More sharing options...
Emistry Posted December 26, 2013 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: Sunday at 05:32 PM Share Posted December 26, 2013 it depend on how your sql table work ... some table that have auto increment value might have problem when you re-import the data since the value are auto generated and act as primary key .. hence it doesnt accept duplication of same primary key / unique key. otherwise you can try use REPLACE INTO ... which will drop the existing same content ... and re-add it back... or ..... you can also try "remove" the content for primary key ... and re-import the data .. if they primary key is self generated. or .... you could change the value of self generated to begin with... Quote Link to comment Share on other sites More sharing options...
Question
realRO
Requesting a SQL import
Specific ID I will import, example account 100000 << I want to import it.
And if I export it back, will it overwritten my old SQL? Other accounts wont be affected? Thanks
Bumpy.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.