Sql Tutorial Development Tutorials, Guides & Insights

SET FOREIGN_KEY_CHECKS = 0;
SOURCE /path/to/backup_filename.sql;
SET FOREIGN_KEY_CHECKS = 1;

This process ensures that foreign key constraints do not interfere with the restoration process.

SELECT * FROM your_table_name
INTO OUTFILE '/path/to/export.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

• /path/to/export.csv: The file where the data will be exported.

For a table employees:

CREATE INDEX idx_department
ON employees (department);

To allow duplicates:

SELECT name FROM employees_us
UNION ALL
SELECT name FROM employees_uk;

SELECT columns
FROM table1
INNER JOIN table2
ON table1.common_column = table2.common_column;

Consider two tables, employees and departments: