Scribd
Upload
17 views2 pages

MySQL Full Basics Guide

MySQL is an open-source relational database system utilized in various applications, with a focus on installation, database creation, and data manipulation. The guide covers essential commands for creating databases and tables, inserting, updating, and deleting data, as well as performing queries with filtering and sorting. It also introduces basic JOIN operations and provides a practice task along with a cheat sheet for quick reference.

Uploaded by

Deepak
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views2 pages

MySQL Full Basics Guide

MySQL is an open-source relational database system utilized in various applications, with a focus on installation, database creation, and data manipulation. The guide covers essential commands for creating databases and tables, inserting, updating, and deleting data, as well as performing queries with filtering and sorting. It also introduces basic JOIN operations and provides a practice task along with a cheat sheet for quick reference.

Uploaded by

Deepak
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

MySQL Basics: Beginner's Guide

1. Introduction to MySQL

MySQL is an open-source relational database system that stores data in tables. It's used in web apps,

enterprise software, and more.

2. Installation & Setup

Use XAMPP or install MySQL directly. Access it via command line or MySQL Workbench.

3. Creating a Database

CREATE DATABASE my_database;

4. Creating Tables

CREATE TABLE users (id INT, name VARCHAR(100), age INT);

5. Inserting Data

INSERT INTO users (id, name, age) VALUES (1, 'John', 25);

6. SELECT Queries

SELECT * FROM users;

SELECT name FROM users WHERE age > 18;

7. Updating Data

UPDATE users SET age = 26 WHERE id = 1;

8. Deleting Data

DELETE FROM users WHERE id = 1;


MySQL Basics: Beginner's Guide

9. Filtering with WHERE

SELECT * FROM users WHERE age > 18 AND name LIKE 'J%';

10. Sorting & Limiting

SELECT * FROM users ORDER BY age DESC LIMIT 5;

11. JOINS (Basics)

SELECT u.name, o.amount FROM users u JOIN orders o ON u.id = o.user_id;

12. MySQL Functions

COUNT(), AVG(), MAX(), MIN(), NOW(), etc.

13. Practice Task

Create a database with a 'students' table and try inserting, updating, and retrieving records.

14. Bonus: Cheat Sheet

- SELECT: get data

- INSERT: add data

- UPDATE: change data

- DELETE: remove data

- WHERE: filter

- JOIN: combine tables

You might also like