[Solved] SQL – Insert 1000 values fast [closed]

by


I don’t know what data base are you using. You can search for “Bulk Insert” for your data base, it allows you to insert complete file in one step.

If you need to create an instruction like this:

INSERT CodesTable VALUES
(91111),
(91112),
...
(91999)

You could open/copy&past the file in query editor. Make a search and replace, searching for new line character (enabling regular expression ‘\n’ usually, verify your software version) and replace it for ‘),(‘ without quotes, or supposing new line is ‘\n’ you could replace with ‘),\n(‘ without quotes.
Then add the first line ‘Insert table values(‘ (without quotes).

Verify that last entry have a closing ‘)’ (without quotes).

Run the script or save it for later use.

solved SQL – Insert 1000 values fast [closed]