How have you used MySQL in your past projects and what tasks have you solved with it?

In my PHP projects, I used MySQL for storing and managing user data, sessions, and also for implementing business logic. Main tasks:

• Storing information about users, their roles, and access rights.
• Implementing CRUD operations for various entities (e.g., products, orders).
• Optimizing queries using indexes and database normalization.
• Using transactions to ensure data integrity during complex operations.

An example of a simple PHP query using PDO:

$stmt = $pdo->prepare('SELECT * FROM users WHERE email = :email');
$stmt->execute(['email' => $email]);
$user = $stmt->fetch();