realRO Posted December 25, 2013 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
Emistry Posted December 26, 2013 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
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.
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.