Setting Up MySQL Docker Container

Step 1: Install Docker

Step 2: Pull the MySQL Docker Image

docker pull mysql:latest

Step 3: Run the MySQL Container

docker run --name talend-mysql -e MYSQL_ROOT_PASSWORD=your_password -e MYSQL_DATABASE=talend_db -p 3306:3306 -d mysql:latest

Step 4: Verify the MySQL Container is Running

docker ps

Step 5: Stopping and Starting the Container

docker stop talend-mysql

docker start talend-mysql

Generate dummy data for a users table in MySQL.

Step 1: Access the database server

docker exec -it talend-mysql mysql -u root -p

Step 2: Select Database

USE talend_db;

Step 3: Create the users Table

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Step 4: Generate Dummy Data

INSERT INTO users (username, email, password) VALUES
('user1', 'user1@example.com', 'password1'),
('user2', 'user2@example.com', 'password2'),
('user3', 'user3@example.com', 'password3'),
('user4', 'user4@example.com', 'password4'),
('user5', 'user5@example.com', 'password5');

Step 5: Verify the Data

SELECT * FROM users;