Jump to content
  • 0

SQL import


Question

Posted

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

Posted

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...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...