Tutorials Programming Tutorials, Guides & Best Practices

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.

To export an entire database, use the following command:

mysqldump -u your_username -p your_database_name > backup.sql

• Index frequently queried columns.
• Remove unused indexes.
• Regularly analyze and maintain indexes.

SELECT name, salary
FROM employees
WHERE department = 'Engineering' AND salary > 70000
ORDER BY salary DESC;

SELECT column1, column2
FROM table
WHERE column IN (
  SELECT column FROM another_table WHERE condition
);

To find customer names who have placed orders over $200:

To fetch employees with their department names:

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