Here are some common commands used in MySQL:
| MySQL Commands | Related Work |
| 1.Insert | Insert Command in MySQL is used to insert data into a tale |
| 2.Select | Select Comand in MySQL is used to retrieve the data in the database |
| 3.Delete | Delete Command in MySQL is used to delete data from the table |
| 4.Update | Update Command in MySQL is used to update an existing datas in a table |
| 5.Create Database | Create Database Command in MySQL is used to create a new database |
| 6.Create Table | Create Table Command in MySQL is used to create a new table |
| 7.Create Index | Create Index Command in MySQL is used to create an index on one or more than one columns of a table |
| 8.Alter Table | Alter Table Command in MySQL is used to modify/edit an existing table |
| 9.Drop Database | Drop Database Command in MySQL is used to Completely delete a database |
| 10.Drop Table | Drop Table Command in MySQL is used to Completely delete a table |
| 11.Drop Index | Drop Index Command in MySQL is used to Completely delete an index |
| 12.Show Databases | Show Databases Command in MySQL is used to display the lists of all the databases on the related server |
| 13.Show Tables | Show Tables Command in MySQL is used to display the lists of all the databases on the related server |
| 14.Grant | Grant Command in MySQL is used to provide the related privileges to the users |
| 15.Revoke | Revoke Command in MySQL is used to revoke the related privileges from the users itself |
| 16.Describe | Describe Command in MySQL is used to describe the structures of a table |
Codeauri Brings More Programming Languages, From Front-End to Back-End Development
Let me deep dive into MySQL Commands below:
1.Insert
This insert command is used to insert data into a table.
You can allocate the values you want to insert, including all the columns to which you want to insert the related values.
For example:
INSERT INTO users (username,address, email) VALUES ('johndoe', 'newyork','[email protected]');
An Above example inserts a new row into the “users” table, with values for the “username”, “address”, “email” columns.
2.Select
3.Delete
4.Update
5.Create Database
6.Create Table
7.Create Index
8.Alter Table
9.Drop Database
10.Drop Table
11.Drop Index
12.Show Databases
13.Show Tables
14.Grant
15.Revoke
16.Describe