Database: SQL: Bulk Loads and Saves

Bulk Load

All systems have a way to load rows into a database from text files, eg from a tab-separated text file. There is no SQL standard for this, but it might be a command like LOAD (eg, MySQL's LOAD DATA).

Bulk Save

There is also always a way to produce these text files that can be used for bulk input. The most common way to do this is an option on the SELECT command, commonly some form of INTO clause, eg, SELECT INTO file ... WHERE ...