SQL Data Import and Export Techniques

Hello Folks,

Photo by Vladislav Klapin on Unsplash

1. MySQL: Importing Data Using LOAD DATA INFILE

LOAD DATA INFILE '/path/to/your/file.csv'
INTO TABLE employees
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(employee_id, first_name, last_name, hire_date, salary);

2. MySQL: Exporting Data Using SELECT INTO OUTFILE

SELECT employee_id, first_name, last_name, salary
INTO OUTFILE '/path/to/your/export_file.csv'
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM employees;

Photo by Stephen Phillips - Hostreviews.co.uk on Unsplash

3. PostgreSQL: Importing Data Using COPY Command

COPY employees (employee_id, first_name, last_name, hire_date, salary)
FROM '/path/to/your/file.csv'
DELIMITER ',' 
CSV HEADER;

4. PostgreSQL: Exporting Data Using COPY TO Command

COPY (SELECT employee_id, first_name, last_name, salary FROM employees)
TO '/path/to/your/export_file.csv'
DELIMITER ',' 
CSV HEADER;

5. SQL Server: Importing Data…