Sql Tutorial Development Tutorials, Guides & Insights

After entering the MySQL shell, you can execute:

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

• /path/to/data.csv: The path to the CSV file.
• your_table_name: The table into which the data will be imported.
• FIELDS TERMINATED BY ',': Specifies the field delimiter.
• ENCLOSED BY '"': Specifies the field enclosure character (if any).
• LINES TERMINATED BY '\n': Specifies the line terminator.
• IGNORE 1 LINES: Ignores the header line in the CSV file (if present).

To export data from a table to a CSV file, use the SELECT INTO OUTFILE statement:

CREATE INDEX index_name
ON table_name (column1, column2);

For a table employees:

To allow duplicates:

SELECT name FROM employees_us
UNION ALL
SELECT name FROM employees_uk;

SELECT employees.name, departments.department_name
FROM employees
RIGHT JOIN departments
ON employees.department_id = departments.department_id;

The FULL JOIN combines the results of both LEFT JOIN and RIGHT JOIN. It returns all records when there is a match in either the left or right table.