Skip to content
Home » MySQL Basic Commands For Beginners

MySQL Basic Commands For Beginners

uploads mysql mysql PNG1

If your are Thinking to Learn MySQL as a DBMS ( Database Management System ), MySQL Is a Good Option for You to Start With a DBMS. MySQL Is Easy to Learn & Uses Most of the English Words Which Any Non-Programmer Guy Can Understand.

What is a Database?

In computing, a database is an organized collection of data stored and accessed electronically from a Computer.

What is MySQL?

MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.

Some of the Basic MySQL Commands

  1. SELECT — Extracts Data from a Database
SELECT  table_name
 FROM table_name;

SELECT Satements Fetch Data from a Database.

2. UPDATE — updates Data in a Database

UPDATE table_name
SET any_column = any_value
WHERE any_column = any_value;

UPDATE Statements Allow Us to Edit Rows in a Table.

3. DELETE — Deletes Data From a Database

DELETE FROM table_name
WHERE any_column = any_value;

DELETE Statements Deletes or Removes the Data From a Database

4. INSERT INTO — Inserts New Data into a Database

INSERT INTO table_name (table_name1, table_name2, table_name3)
VALUES (value_1, ‘value_2’, value_3);

INSERT Statements Add a New Data to a Table.

5. CREATE DATABASE — Creates a New Database

CREATE DATABASE databasename;

CREATE DATABASE Statements Create a New MySQL database.

6. ALTER DATABASE — modifies a Database

ALTER DATABASE database_name

ALTER DATABASE Statements Change the Characteristics of a Database.

7. CREATE TABLE — Creates a New Table In MySQL

CREATE TABLE table_name ( column_1 datatype, column_2 datatype, column_3 datatype );

CREATE TABLE Statements Create a New Table in the Database.

8. ALTER TABLE — Modifies a Table

ALTER TABLE table_name
ADD column_name datatype;

ALTER TABLE Statements Add, Delete, or Modify Columns in an Existing Table.

9. DROP TABLE — Deletes a Table

DROP TABLE table_name;

DROP TABLE Statements Drop an Existing Table in a Database.

10. CREATE INDEX — Creates an Index

CREATE INDEX index_name
ON table_name (column_name1, column_name2);

Index statements create on existing tables to retrieve the rows quickly.

11. DROP INDEX — Deletes an Index

ALTER TABLE table_name
DROP INDEX index_name;

DROP INDEX Statements Delete or Drops an index in a table.

This is For It Programmer, See you In the Next One 🔥

Read Also: https://mrprogrammer.in/index.php/best-python-gui-framework-in-2022-for-beginners

7 thoughts on “MySQL Basic Commands For Beginners”

  1. Thx Bro, I was Learning MySQL & Just Searching For MySQL Basic Commands &
    I Saw your Post This Really Helped Me a Lot.

Leave a Reply

Your email address will not be published. Required fields are marked *

You cannot copy content of this page

Top 10 Programming Languages to Learn In 2023! 9 Best Extensions For Web Developers! | Chrome Extensions For Web Developers Web Development Roadmap Best Resources to Learn PYTHON FREE! Web Vs App Development- Which one is Better?