My SQL Tutorial – Geek Slack

About Course

MySQL Basics

Introduction to MySQL

MySQL is a popular relational database management system used for storing and managing data.

Connecting to MySQL

To connect to MySQL, you can use various tools like MySQL Workbench, phpMyAdmin, or connect programmatically using languages like PHP, Python, etc.

Creating a Database

Example: Creating a Database

CREATE DATABASE my_database;

This SQL command creates a new database named my_database.

Creating a Table

Example: Creating a Table

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

This SQL command creates a table named users with columns for user_id, username, email, and created_at.

Inserting Data into a Table

Example: Inserting Data

INSERT INTO users (username, email) 
VALUES ('john_doe', 'john.doe@example.com');

This SQL command inserts a new record into the users table with values for username and email.

Querying Data from a Table

Example: Querying Data

SELECT * FROM users;

This SQL command selects all columns from the users table, retrieving all records.

Updating Data in a Table

Example: Updating Data

UPDATE users SET email = 'john_new@example.com' WHERE user_id = 1;

This SQL command updates the email of the user with user_id 1 in the users table.

Deleting Data from a Table

Example: Deleting Data

DELETE FROM users WHERE user_id = 1;

This SQL command deletes the user with user_id 1 from the users table.

Conclusion

These are basic operations in MySQL to create databases, tables, insert, query, update, and delete data. Understanding these fundamentals is essential for working with MySQL databases.

Course Content

MySQL

Student Ratings & Reviews

No Review Yet