What is MYSQL ? - Structured Query Language (SQL)

MYSQL (Structured Query Language) is an open-source relational database management system (RDBMS). It is widely used for managing and organizing data in databases. It uses Structured Query Language (SQL) for accessing, adding, and managing the data held in a database.

How to use MySQL

Installation

To start using , you first need to install it on your system. It can be installed on various operating systems like Windows, Linux, and macOS. Installation guides are available on the official MySQL website.

Starting the MySQL Server

Once SQL is installed, you need to start the it’s server. On many systems, this can be done via a command line or terminal:

Windows: Use the MySQL Workbench or MySQL Command Line Client.

Linux/Mac: Use the terminal to start the MySQL server with a command like sudo service mysql start.

Connecting to MYSQL (Structured Query Language)

You can connect to MySQL using various tools:

MySQL Command Line Client: A command-line interface for interacting with the MySQL server.

MySQL Workbench: A graphical interface for working with MySQL databases.

Third-party tools: Tools like phpMyAdmin, DBeaver, or other database management tools.

Basic SQL Commands

Here are some basic SQL commands to get you started:

`/// Creating a Database///`
CREATE DATABASE my_database;


`///Selecting a Database///`
USE my_database;


`///Creating a Table///`
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(100)    
);


`///Inserting data///`
INSERT INTO users (name,email) Values ('John Doe', 'john@example.com');


`///Querying data///`
SELECT * FROM users;


`///Updating Data///`
UPDATE users SET email = 'john.doe@example.com' WHERE name = 'John Doe';


`///Deleting Data///`
DELETE FROM users WHERE name = 'John Doe';