====== MySQL Basics ======


==== Connecting to MySQL ====


To connect to MySQL, use the following command:

<code>
mysql -u username -p
</code>

Enter the password when prompted.

==== Creating a Database ====

<code>
CREATE DATABASE my_database;
</code>

This command creates a new database named my_database.

==== Selecting a Database ====

<code>
USE my_database;
</code>

This command selects my_database for subsequent operations.

==== Creating a Table ====

<code>
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
</code>

This command creates a users table with fields for user ID, name, email, password, and creation time.

==== Inserting Data ====

<code>
INSERT INTO users (name, email, password) VALUES ('John Doe', 'john@example.com', 'securepassword123');
</code>

This inserts a record into the users table.

==== Querying Data ====


SELECT * FROM users;

This retrieves all records from the users table.